Reference no: EM132095862
"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)
|
Representations of business data flow and processes
: Assignment - Literature Bonanza - Select appropriate IT solutions for business functions - Apply business information software for data visualization
|
|
Prepare january journal entry to record the bond issuance
: Legacy issues $710,000 of 8.0%, four year bonds dated January 1, 2015, Prepare the January 1, 2015, journal entry to record the bond's issuance
|
|
Understanding of the key topics
: This assessment aims to develop and gauge student understanding of the key topics covered so far by answering the following questions.
|
|
Prepare a multiple-step income statement
: Presented below is information for Furlow Company for the month of March 2014. Prepare a multiple-step income statement
|
|
Find all customers whose balances are less than their limits
: Find all customers whose balances are less than their credit limits. How many customers have balances which are less than their credit limits.
|
|
Prepare separate entries for each transaction on the books
: On June 10, Tuzun Company purchased $9,700 of merchandise from Epps Company, Prepare separate entries for each transaction on the books of Tuzun Company
|
|
Write a program with an array of seven payroll objects
: Design a PayRoll class that has data members for an employee's first and last name, hourly pay rate, number of hours worked.
|
|
Assessment-idea generation
: The objective of this individual assessment submission is to learn how to develop a business idea, complemented by brainstorming and leveraging the insights
|
|
How much depreciation expense should the company recognize
: A company purchased a delivery van for $28,000 with a salvage value of $3,000 on September 1, how much depreciation expense should the company recognize
|