Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assignment 5 Understanding SQL 100 points: (Questions 1 to 7 each worth 12 points, Question 8 worth 16 points) Please provide detail answer and explain
Assignment 5 Understanding SQL 100 points: (Questions 1 to 7 each worth 12 points, Question 8 worth 16 points) Please provide detail answer and explain If you run the following SQL queries what will be on your report. In simple words what will be the output of each of the following queries? These questions are related to Databases Premiere Products described in lecture slide Database Concepts posted under this week for your review. Please read the PP slides to understand the Premiere Products database and answer the following questions. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; Your Answer should be: The output will list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances Now read each of the following 7 queries and submit a word document with your answers like the above example. Please only submit your answers do not repeat the queries. 1) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='35' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum = Orders. CustomerNum ; 2) SELECT Description FROM Part WHERE Warehouse =3OR OnHand >20 3) SELECT CustomerNum, CustomerName, Street, City, State, Zip FROM Customer WHERE Street LIKE *Oxford"; 4) SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName; 5) SELECT CustomerNum, CustomerName, CreditLimit, RepNum FROM Customer WHERE RepNum = ' 35 AND CreditLimit>2000; 6) SELECT CustomerNum, CustomerName, CreditLimit, RepNum FROM Customer WHERE RepNum =135 OR CreditLimit
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started