Question: 1- Write SQL queries for the following: Find the maximum value of invoice total and the sum of all invoice_total in the invoices table using
1- Write SQL queries for the following: Find the maximum value of invoice total and the sum of all invoice_total in the invoices table using a single query. Retrieve the invoice_id and invoice_total where invoice total is greater than 1000 dollars but less 10000 dollars and order the invoice_total in descending order. Retrieve the distinct states in the vendors table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
