Use assignment5 to show sums of line totals for each invoice
13 Pages559 Words82 Views
Added on 2019-11-29
About This Document
SQL Statement SELECT INV_NUMBER, ROUND(SUM(LINE_TOTAL), 2) AS SUM FROM line GROUP BY INV_NUMBER; Result Query 2 Locate the record in the vendor table that does not have a value for the V_STATE SQL Statement SELECT * FROM vendor WHERE V_STATE IS NULL; Result Query 3 Find the customers whose balance is greater than 200 but less than 300 SQL Statement SELECT * FROM customer WHERE CUS_BALANCE > 200 AND C
Use assignment5 to show sums of line totals for each invoice
Before executing any of the Query please select the database ‘assignment5’ by executing the below command: use assignment5;Query 1Show sums of line totals for each invoice.SQL StatementSELECT INV_NUMBER, ROUND(SUM(LINE_TOTAL), 2) AS SUMFROM lineGROUP BY INV_NUMBER;Result
Query 2Locate the record in the vendor table that does not have a value for the attribute V_STATESQL StatementSELECT * FROM vendor WHERE V_STATE IS NULL;Result
End of preview
Want to access all the pages? Upload your documents or become a member.