WRITE SQL STATEMENT FOR FOLLOWING questions 1. From the STUDENTS table, select the Surname of students...

Transcribed Image Text:

WRITE SQL STATEMENT FOR FOLLOWING questions 1. From the STUDENTS table, select the Surname of students with ids between 37 and 52, and display their surnames in ascending alphabetical order. 2. From the STUDENTS table, select the Name and Surname, and display the first 5 students by Surname in reverse alphabetical order 3. Get the records from the BORROWS table for anything with a taken date in May 2016. 4. Get the records from the BOOKS table for any book with a Typeld of 7, 10, and 18. 5. Get the records from the BOOKS table where the title begins with 'The' and sort by page count in descending order. WRITE SQL STATEMENT FOR FOLLOWING questions 1. From the STUDENTS table, select the Surname of students with ids between 37 and 52, and display their surnames in ascending alphabetical order. 2. From the STUDENTS table, select the Name and Surname, and display the first 5 students by Surname in reverse alphabetical order 3. Get the records from the BORROWS table for anything with a taken date in May 2016. 4. Get the records from the BOOKS table for any book with a Typeld of 7, 10, and 18. 5. Get the records from the BOOKS table where the title begins with 'The' and sort by page count in descending order.

Answer rating: 100% (QA)

Here are the SQL statements for your questions Select the Surname of students with ag... View the full answer