Write a SELECT statement that uses the ranking functions to rank products by the total quantity sold. Return these columns: The product_name column from the Products table A column named total_quantity that shows the sum of the quantity for each product in the Order_Items table A column named rank that uses the RANK function to rank the total quantity in descending sequence A column named dense_rank that uses the DENSE_RANK function to rank the total quantity in descending sequence

Write a SELECT statement that uses the ranking functions to rank products by the total quantity sold. Return these columns: The product_name column from the Products table A column named total_quantity that shows the sum of the quantity for each product in the Order_Items table A column named rank that uses the RANK function to rank the total quantity in descending sequence A column named dense_rank that uses the DENSE_RANK function to rank the total quantity in descending sequence

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section8.2: Lookup Tables And The Iferror Function

Problem 4QC

See similar textbooks

Similar questions

What does an asterisk () in the SELECT clause of a SELECT statement represent?
What does the funnel symbol that appears next to a field’s name in the Query Builder dialog box indicate? The field is used in a SELECT statement’s ORDER BY clause. The field is used in a SELECT statement’s WHERE clause. The field is the primary key. The field is the foreign key.
Which of the following lines of the SELECT statement contains an error? 1 SELECT ISBN, 2 retail-cost 3 FROM books; a. line 1 b. line 2 c. line 3 d. There are no errors.
What is the purpose of the SELECT statement?
Which of the following lines of the SELECT statement contains an error? 1 SELECT * 2 FROM publishers; line 1 line 2 There are no errors.
Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100. The results should be sorted bythe Num_Shares column in ascending order.
Write a SELECT statement returns these columns from the orders table: The invoice_id column as Invoice_ID The invoice_date column as Invoice_Date The invoice_due_date column as Invoice_Due_Date The payment_date column in the format 'Mon/DD/YY' as Formatted_Payment_Date The invoice_due_date column in the format 'Weekday, Month Day of month with suffix, YYYY' (ex: 'Tuesday, April 23rd, 2019') as Long_Invoice_Due_Date The invoice_due_date plus 60 days as Expected_Payment_Date (Column must remain a date type) The number of days between the invoice_due_date and the payment_date as Time_To_Pay
9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all vendors and the total due for each vendor. Return 3 Columns: The vendor id from the Invoices table. The balance due (invoice_total-payment_total-credit_total) for each invoice in the invoices table with a balance greater than 0. The total balance due for all vendors in the Invoices table. Modify the column that contains the balance due for each vendor so it contains a cumulative total by balance due.
Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns. In addition, you must calculate the order total from the columns in the OrderItems table. Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return two columns: the customer�s email address and the largest order for that customer. To do this, you can group the result set by the EmailAddress column.
Write a SELECT statement that uses a correlated subquery to return one row per customer, representing the customer's oldest order (the one with the earliest date). Each row should include these five columns: first_name last_name order_id order_date total quantity Include only orders with a total order quantity greater than 2. Subject: MySQL
Write a SELECT statement that returns the following columns from the PRODUCT_INFORMATION table. Sort the results by PRODUCT_ID in ascending order. 1. PRODUCT_ID 2. PRODUCT_NAME 3. LIST_PRICE ○ Use the TO_CHAR function to convert LIST_PRICE to a character string with the currency formatting Give this field an alias of PRICE
Write a SELECT statement that returns two columns basedon the EMPLOYEES table. Contact, is the employeelastname and the first initial of the first name. The secondcolumn, Phone, is the homephone without the area code.Only return rows for those employees in the 206 areacode, sort the results by the last name.