1.Write a query to display the student Id, first name, last name and street of all the students who all from 'Chennai' or 'Bangalore'. Sort the records based the first name in ascending order.Write a query to display the student Id, first name, last name and street of all the students who all from 'Chennai' or 'Bangalore'. Sort the records based the first name in ascending order.
1.Write a query to display the student Id, first name, last name and street of all the students who all from 'Chennai' or 'Bangalore'. Sort the records based the first name in ascending order.Write a query to display the student Id, first name, last name and street of all the students who all from 'Chennai' or 'Bangalore'. Sort the records based the first name in ascending order.
2.Write a query to display the name of departments that are not present in the block number 3. Sort the records based on the department name in ascending order.
3.Write a query to display the guest id, name, email and phone number of all the guest if and only if the phone number is available. Sort the records based on the name in ascending order.
The resort manager wants to know the details of the guest who brought their children to the resort.
4.Write a query to display the guest id, resort id, number of days they have stayed (give the alias name as NUMBEROFDAYS), number of adults, number of children. Display the records based on the descending order of the child count.
(Hint : Total number of days is calculated based on the difference between from date and to date)
5.Write a query to display the Course Id and Course Name with duration between 2 and 3 months and the fees is less than 5000. Sort the records based on the course name in descending order.
(Hint : Data is case sensitive)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
