Display user name and their city who have booked their tickets not by using HDFC bank for any of the bookings. Sort the result based on user name.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
do you have table definitions with sample data? that would really help us to help you.
what have you tried so far? are the columns in different tables? what should we join on? how would we know whether or not a user booked using HDFC bank?
Hi, @KenJ, I'm attaching the table definitions below.
Answers Answers and Comments
19 People are following this question.
I'm Unable to write this below query to display the multiple toppers in alphabetical order.
Count active Customers based on item master
Please help with the following queries. Rectify if they are wrong.
Need to combine two Select Statements
Query two tables to get results without a JOIN