SQL Query do the following
Write a query to display the book number, title, subject, and cost for all books that are on the subjects of “Middleware” or “Cloud”, and that cost more than $70 sorted by book number (Figure P7.69).
In the SQL Query do the following
Select clause and from clause: Display the columns specified above in the problem statement from the BOOK table
Where clause: Only displaying information for subjects of “Middleware” OR “Cloud” and for books that cost more than $70. So here you will be using the OR operator and also paying attention to where the parenthesis will need to be placed so both the required conditions are met.
Order by clause: looking at Figure 7.69, determine what the results should be sorted by.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
