Running head: SQL QUERY USING SQLITESQL Query Using SQLiteName of the StudentStudent IDSubject Code
SQL QUERY USING SQLITE1Part A:Query 1:select * from vendor where v_state = '';Query 2:select * from customer where CUS_BALANCE>300 AND CUS_BALANCE<400;Query 3:Select DISTINCT CUS_LNAME from customer inner join invoice oncustomer.CUS_CODE = invoice.CUS_CODE;
SQL QUERY USING SQLITE2Query 4:select max (CUS_BALANCE) from customer;Query 5:Select distinct CUS_CODE from customer where NOT EXISTS (select * from invoicewhere customer.CUS_CODE = invoice.CUS_CODE);Query 6:Select distinct (CUS_FNAME || ' ' || CUS_LNAME) As 'Customer Name' from customerwhere NOT EXISTS (select * from invoice where customer.CUS_CODE =invoice.CUS_CODE);
End of preview
Want to access all the pages? Upload your documents or become a member.