Running head: SQL QUERIES USING WORKBENCHSQL Queries Using WorkbenchName of the StudentName of the University
SQL QUERIES USING WORKBENCH1Part A - DMLQuery 1:SELECT * FROM vendor WHERE v_state = '';Query 2:select * from Customer where CUS_BALANCE>300 AND CUS_BALANCE<400;
SQL QUERIES USING WORKBENCH2Query 3:SELECT DISTINCT CONCAT(CUS_FNAME, ' ', CUS_LNAME) AS 'Customer Name'FROM Customer cus INNER JOIN Invoice inv ON cus.CUS_CODE = inv.CUS_CODE;
SQL QUERIES USING WORKBENCH3Query 4:SELECT DISTINCT CONCAT(CUS_FNAME, ' ', CUS_LNAME) AS 'Customer Name'FROM Customer cus INNER JOIN Invoice inv ON cus.CUS_CODE = inv.CUS_CODE;
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
SQL Statement and Result Assignmentlg...
|12
|1135
|69
SQL Query Using SQLite - PDFlg...
|6
|399
|84
Use assignment5 to show sums of line totals for each invoicelg...