SQL Assignment: SQL Queries Using Workbench

Added on - 28 May 2020

  • 14

    pages

  • 432

    words

  • 8

    views

  • 0

    downloads

Showing pages 1 to 4 of 14 pages
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;
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document