"Please help with this database "
Lab - Single Table SQL Queries: Premiere database
Construct the following queries in SQL and execute them in MySQL database you have created (The Premiere database).
Your output for each query must contain the SQL code and the resulting table. You can copy & paste your SQL code and output table below each query question. You can submit your lab report in a MS Word or PDF file via Blackboard. I will also look at your work in class.
a) List the names of customers with credit limits of $7,500 0r less.
(P&L page 125 # 3)
b) List the order number for each order placed by customer 148 on 10/23/2007.
Hint: The default DATE data type in MySQL stores dates in the format ‘yyyy-mm-dd', enclosed in single quotes. (P&L page 125 # 4)
c) Find all customers whose balances are less than their credit limits.
d) How many customers have balances which are less than their credit limits.
(P&L page 125 #14)
e) Find the total of the balances for all customers whose sales rep is 65 and whose balances are less than their credit limits. (P&L page 125 #15)