Index:

S. No. Content Page No.
1. Screen shots of Queries 4-16

2. References 17

QUERY 1
Select name,address from
(
select CONCAT(emp_fname,' ',emp_lname) as name , CONCAT(address_st,', ', address_city, ' ',address_state, ' ', address_postcode ) as address, emp_salary_hourly as salary from employee,casual,address where (employee.emp_id = casual.emp_id and employee.address_id_postal= address.address_id) union select CONCAT(emp_fname,' ',emp_lname) as name , CONCAT(address_st,', ', address_city ' ',address_ state, ' ',address_postcode ) as address, emp_salary_yearly as salary from employee, fulltime, address where (employee.emp_id = fulltime.emp_id and employee.address_id_postal= address.address_id)) temp order by salary ;

[pic]

QUERY 2

select CONCAT(Cust_FName ,' ' , Cust_LName) as Name, CustOrd_Date from CUSTOMERORDER, CUSTOMER where (CUSTOMERORDER.Cust_Number = CUSTOMER.Cust_Number) order by CustOrd_Date desc limit 1 ;

[pic]

QUERY 3

select str_name,CONCAT(address_st,',',address_city, '',address_state,' ',address_postcode)as address from store,address, where store.address_id= address.address_id) order by str_name;

[pic]

QUERY 4

select Cust_Number , CONCAT(Cust_FName,' ',Cust_LName) as Name from CUSTOMER where Cust_Number Not In ( select CUSTOMER.Cust_Number from CUSTOMER, CUSTOMERORDER where CUSTOMER.Cust_Number = CUSTOMERORDER.Cust_Number ) ,

[pic]

Query 5 select CONCAT(emp_fname,' ',emp_lname) as name from employee where emp_id in( select emp_id from jobtype, casual where ( jobtype.jobtype_id = casual.jobtype_id and jobtype_name= 'Accountant' ) union select emp_id from jobtype, fulltime where ( jobtype.jobtype_id= fulltime.jobtype_id and jobtype_name= 'Accountant' ) ) ;

[pic]

Query 6 select * from
( select
ProductNum, OTHERPRODUCT.OthProd_Desc, Inv_QntyOnHand from INVENTORY, OTHERPRODUCT where ( OTHERPRODUCT.Prod_Num = INVENTORY.ProductNum ) union select ProductNum, CD_Title, Inv_QntyOnHand from INVENTORY, CD where ( CD.Prod_Num = INVENTORY.ProductNum ) ) temp ;

[pic]

Query 7 select * from ( select orderline.prod_num, othprod_desc as Name, ordln_qnty from orderline, otherproduct where ( ordln_datearrived