Which query determines the customers who have ordered the most books from JustLee Books?  (refer to the tables in the JustLee Books database.)a. SELECT customer# FROM ordersJOIN orderitems USING(order#)HAVING SUM(quantity) = (SELECTMAX(SUM(quantity)) FROM ordersJOIN orderitems USING(order#)GROUP BY customer#) GROUP BY customer#;b. SELECT customer# FROM ordersJOIN orderitems USING(order#)WHERE SUM(quantity) = (SELECTMAX(SUM(quantity)) FROM orderitemsGROUP BY customer#);c. SELECT customer# FROM ordersWHERE MAX(SUM(quantity)) = (SELECTMAX(SUM(quantity) FROM orderitemsGROUP BY order#);d. SELECT customer# FROM ordersHAVING quantity = (SELECT MAX(SUM(quantity))FROM orderitemsGROUP BY customer#);

Q: What is the result of the query below:   SELECT V_CODE, COUNT (P_CODE) FROM PRODUCT HAVING V_CODE…

A: Answer: Data is filtered using the having clause in accordance with the specified requirements.…

Q: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Design a query of Stores with the following: Store Name, Store Size, Sum of order amounts,  Percent…

A: JOIN Based on a common column between two or more tables, a JOIN clause is used to merge rows from…

Q: In the following PL/SQL block, determine the values and data types for each of the following cases:…

A: conclusion:In the nested block:v_customer holds a numeric value of 201 with a data type of…

Q: Some rows of a User table are shown below:   User ucode name phone scode 7 Alex 847 - 3902…

A: Names and phone numbers are among the details about different users that are included in the User…

Q: reate a query that SELECT all of the EMPLOYEES from the EMPLOYEE TABLE that are Mangers.   Include…

A: SQL provides a standardized way to communicate with databases regardless of the specific RDBMS being…

Q: FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery…

A: Given subquery SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: Create a SQL query that selects OrderID and OrderDate from the Orders database and OrderDetailID…

A: Definition A JOIN clause is used to join data from more than "2" tables together based on a common…

Q: Because the SELECT clause contains the Customer* column, which clause must be included for the query…

A: Clause used in the query The SELECT statement returns a result set of records from one or more…

Q: Write a query to display all vendors sorted by vendor name.   Write a query to display the product…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Write an SQL query using the ALTER TABLE and ADD operator to add anattribute named ORDERDATE with…

A: ALTER TABLE command: The ALTER TABLE command is used to add new columns, modify columns in an…

Q: List the owner number and last name for all owners located in the city of Seattle. Your query should…

A: Since no name is given so i am assuming the name of the table is OWNER

Q: 1. Write the SQL query to show all invoices (LGINVOICE) with a total (INV_TOTAL) of at least $100.…

A: Note: Due to company policies I am compelled to solve only one question and that is the first…

Q: Write an SQL query that will select OrderID and OrderDate from theOrders table and OrderDetailID…

A: To combine rows from more than “2” tables based on a related column between them, a JOIN clause is…

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.