DB Query Form By Dutch Casadaban
Select a Predefined Query (Optional):
-- Choose a query to populate the SQL box --
Query 1: Show the subject names of books supplied by supplier2.
Query 2: Show the name and price of the most expensive book supplied by supplier3.
Query 3: Show the unique names of all books ordered by lastname1 firstname1.
Query 4: Show the title of books which have more than 10 units in stock.
Query 5: Show the total price lastname1 firstname1 has paid for the books.
Query 6: Show the names of the customers who have paid less than $80 in totals.
Query 7: Show the name of books supplied by supplier2.
Query 8: Show the total price each customer paid and their names. List the result in descending price.
Query 9: Show the names of all the books shipped on 08/04/2016 and their shippers' names.
Query 10: Show the unique names of all the books lastname1 firstname1 and lastname4 firstname4 both ordered.
Query 11: Show the names of all the books lastname6 firstname6 was responsible for.
Query 12: Show the names of all the ordered books and their total quantities. List the result in ascending quantity.
Query 13: Show the names of the customers who ordered at least 2 books.
Query 14: Show the name of the customers who have ordered at least a book in category3 or category4 and the book names.
Query 15: Show the name of the customer who has ordered at least one book written by author1.
Query 16: Show the name and total sale (price of orders) of each employee.
Query 17: Show the book names and their respective quantities for open orders (the orders which have not been shipped) at midnight 08/04/2016.
Query 18: Show the names of customers who have ordered more than 1 book and the corresponding quantities. List the result in the descending quantity.
Query 19: Show the names of customers who have ordered more than 3 books and their respective telephone numbers.
SQL Query:
Run Query
Clear