MIS 582 Week 3 Course Project; SQL Queries and Screenshots

Course Project DeVry University College of Engineering and Information Sciences Course Number: MIS582 Course Project Deliverable: 3 Part I: Tables Created: Screenshot of tables below: select * from customer; select * from invoice; select * from line; select * from product; select * from vendor; PART II: Single table queries screenshots Problem 1: Write the SQL code required to list the product code, description, and price from the product table. Take a screenshot of your results select P_CODE, P_DESCRIPT, P_PRICE from PRODUCT; 914400228587 Problem 2: Modify the query above to only show those products that cost more than 20. Take a screenshot of your results. select P_CODE, P_DESCRIPT, P_PRICE from PRODUCT where P_PRICE > 20; 914400229297 Problem 3: Modify the query above to show the results with price descending. Take a screenshot of your results. select P_CODE, P_DESCRIPT, P_PRICE from PRODUCT where P_PRICE > 20 order by P_PRICE desc