Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

Engineering


Home >> Computer Engineering

"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)

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M93083333

Have any Question?


Related Questions in Computer Engineering

1 write code in the method linearsearch in

1. Write code in the method linearSearch() in "SearchMethods"class which finds the element in an array using linear search approach and returns its index to the calling main method, otherwise it returns -1. 2. Write code ...

Subnetting1 as system administrator you need to create 10

Subnetting 1) As system administrator, you need to create 10 subnets for the Network Address: 192.168.1.0 with a minimum of 10 hosts per subnet. Room for future expansion to more subnets is desirable. Create a table with ...

The monthly sales demand for a new product is uncertain but

The monthly sales demand for a new product is uncertain, but it is considered to be adequately described by a normal random variable with mean 50,000 units and variance 100,000,000. (a) A factory to manufacture the new p ...

Question suppose you are given a turing machine m not

Question : Suppose you are given a Turing machine M (not necessarily a decider), a string w, and a magic genie. You can ask the magic genie whether a certain Turing machine halts on a certain input string, and the genie ...

What do you gain from being able to see the data in a

What do you gain from being able to "see" the data in a graphic presentation, that a table of the data may not readily provide? Discuss and explain why.

In a software design meeting in your company your manager

In a software design meeting in your company, your manager says that one of the most important engines of the Record Keeping System you are developing is the Index Sorting Engine. Your coworker quickly jumps in and says ...

How do you calculate the number of atoms given the weight

How do you calculate the number of atoms given the weight of an element, such as nitrogen?

Question suppose you want to achieve a speedup of 90 times

Question : Suppose you want to achieve a speedup of 90 times faster with 100 processors. What percentage of the original computation can be sequential? Assume one byte data value is 1101, 1000(binary). When we decode the ...

Fully explain at least one reason why many developing

Fully explain at least one reason why many developing countries suffered serious debt crisis in the early 1980s. Does this reason you explained in debt support Krueger & Srinivasan's argument? Why or why not? How could t ...

The equation of regression line for sons heighty in inches

The equation of regression line for son's height(y) in inches versus father's height in inches is y = 35 + 0.5x. For a 72 inch tall father, what would we predict for the son's height?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved