subject

For this assignment, you will display information from a microsoft access database by using sql commands. using the microsoft access database theresa's trees, write sql statements for the given tasks. once complete, copy the sql statements from microsoft access and paste them in a microsoft word document that will be submitted along with part ii of the assignment. write an sql statement: • to display all the information from the customer table • to display each shipping date for customer 1 from the invoice table note: display both the customer number and the shipping date. • to display the names of all the trees that cost at least $200.00 • to display all the information for invoice number 2 • to list the phone and last name of all customers • to list the phone, first name, and last name of all customers whose last name starts with "j" • to return the number of customers • to determine the average total invoice amount • to show all the items ordered from invoice number 3 to show the first and last names along with the invoice number of all customers with an invoice of at least $250.00

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 02:00
Alocal reaction will occur at the site of the exposure such as irritation or damage to the skin eye or local reaction will occur at the site of the exposure such as irritation or damage to the skin ireland lounges
Answers: 3
question
Computers and Technology, 22.06.2019 06:00
Write a program that uses a widgetviewer object to do the following: generate two random integers between 1 and 9 (inclusive). name one of them x, the other y. display them to the user using jlabel objects. create a jlabel object displaying the text "enter an operation number." create a jtextfield for the user's input. create a jbutton displaying the text "press here when you've entered your operation." use addandwait to add it to the widgetviewer object. when the user clicks the jbutton, evaluate operation in the following order to determine the one and only mathematical operation to perform on x and y. use a jlabel to display the result. if operation is between 1 and 10 inclusive, add x and y. if operation is evenly divisible by 4, subtract y from x. if operation is evenly divisible by 5, use integer division to divide y into x. if operation is an even number, use floating point division to divide y into x. if none of the other tests on operation apply, multiply x and y. note: operation can be negative or zero.
Answers: 2
question
Computers and Technology, 22.06.2019 11:30
What do character formats do for your document's message? a.set the tone b.provide organization c.provide clarity d.set how texts align with documents
Answers: 2
question
Computers and Technology, 22.06.2019 12:10
1. declare a constant named cents_per_pound and initialize with 25. 2. get the shipping weight from user input storing the weight into shipweightpounds. 3. using flat_fee_cents and cents_per_pound constants, assign shipcostcents with the cost of shipping a package weighing shipweightpounds.
Answers: 2
You know the right answer?
For this assignment, you will display information from a microsoft access database by using sql comm...
Questions
question
English, 08.05.2021 20:10
question
Mathematics, 08.05.2021 20:10
question
Chemistry, 08.05.2021 20:10