Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

WRITE SQL STATEMENT FOR FOLLOWING questions 1. From the STUDENTS table, select the Surname of students with ids between 37 and 52, and display

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

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.

Step by Step Solution

3.48 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

Here are the SQL statements for your questions Select the Surname of students with ag... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Robert F Blitzer

7th Edition

013449492X, 9780134453262

More Books

Students also viewed these Databases questions