CUSTOMER Customer Customerld - FirstName LastName StreetAddress City State ZipCode PhoneNumbe - Click to Add 1 Sally Smith 2601 Holly Court Baltimore MD 21228 4108695532 2 Karen Walters 46 Tealeaf Road Baltimore MD 21236 4102568831 3 Thomas Williams 243555 Ambermill Stree Frederick MD 21703 4 Cecilia Jamil 18 Cochoran Way Frederick MD 21702 5 Bryan Henley 1 Ocean Street Frederick MD 21705 4435109733 6 Thomas Wright 34 Ridge Road Apt. 3 Frederick MD 21702 4104512394 7 Torey 8 Sam Watson 675 Broad Street Bel Air MD 21014 4435453311 Gonzales 16 Rossville Blvd Baltimore MD 21237 7814223451 9 Robert 46 Greenwood Circle Edgemere 8 Tiger Lane, First floor Baltimore Paisley MD 21219 3016775444 10 Katura Jimenez MD 21222 11 Tammy Knott 2344 Wise Avenue Baltimore MD 21222 4107662301 12 Josh Franz 16 Silver Spring Road Baltimore MD 21236 13 Michele Savarese 501 Boston Street Baltimore MD 21224 4106753814 Owings Mills 512 Blythe Court Apt B Columbia 14 Scott O'Leary 451 Painters Mill Road MD 21117 15 Tyler Hawkins MD 21045 6175446300 16 Sonya Patel 9948 Beaver Dam Road Hunt Valley MD 21031 4432109777 17 Karen Helfrich 4 Liberty Road Randallstown MD 21133 4107665511 18 Scott Abrams 5130 Wilkens Ave Baltimore MD 21228 3012771007 19 Susan Geaney 45 Cockeysville Road, A; Hunt Valley MD 21031 4439912397 20 David lenner 675 Grand Cental Avenu Owings Mills 21117 4437664519 FLOWER Flower Itemld ItemDescription Price Click to Add 1 Red Rose Long Stem Individual 2 Red Rose Long Stem Dozen 3 Red and White Rose Bouquet $5.99 $40.99 $38.99 4 Bouquet- Roses Valentines Day $45.99 5 Bouquet- Mother's Day Small $29.99 6 Bouquet- Mother's Day Medium 7 Bouquet- Mother's Day Large 8 Bouquet -Apology-Small 9 Bouquet- Apology- Medium 10 Bouquet- Apology- Large 11 Bouquet- Birthday Mix 12 Bouquet - Holiday $49.99 $69.99 $19.99 $39.99 $99.99 $25.99 $29.99 13 Bouquet- All Occasion $29.99 14 Bouquet- All Occasion with Vase $39.99 15 Bouquet- All Occasion with Teddy Bear $39.99 16 Bouquet- All Occasion with Teddy Bear and Vase $49.99

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: LIST THE FIRST AND LAST NAMES OF ALL OWNERS WHO OWN A TWO-BEDROOM PROPERTY. USE THE IN OPERATOR IN…

A: Considering there are 2 tables:-  OWNER: which holds the OWNER_NUM, FIRST_NAME, and LAST_NAME…

Q: What did each card cost? Show the card number, player last name, team name, price, price with 5%…

A:

Q: Write the SQL code that will compute the total number of hours worked and total amount billed by all…

A: To compute the total number of hours worked and total amount billed by all workers, we need to have…

Q: Write a query to list the book number, title, and number of times each book has been checked out…

A: Query The query for viewing book number, title and the number of times each book had been checked…

Q: Use SQL and TAL Distributors database to complete the following questions: List the item number and…

A: List the item number and description for all items. The descriptions should appear in uppercase…

Q: Create a query to show the total number of orders (i.e., count of orders) for each customer. The…

A: We have to create a query for the given requirements.

Q: Use SQL commands to finish the questions. Please show BOTH SQL commands and results in your answers.…

A: Hi.. Check below for answer query. Here i give a correct query if you already have table and…

Q: --List all products whose unit price is less than the average price. --List the shipper id,…

A: Given: consider the tables as. product { productID, productNAME, price_per_unit, category_product }…

Q: Without re-creating the table write one sql statement to answer this question. Change the definition…

A: Actually, database is a used to store the data and we can change ,manipulate and access the data.

Q: Report the name of the customer who bought the most expensive product. sql

A: According to the information given:- We have to write query  in order to get the name of the…

Q: Write the SQL statement that shows the count of invoices, the highest invoice total, the lowest…

A: Since schema of the table is not mentioned, I am assuming that table has invoices column. The query…

Q: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

Q: CUSTOMER aus CODE CUS LNAME CUS FNAME CuS INITIAL CUS AREACODE CuS PHONE CUS BALANCE PRODUCT P cODE…

A: SQL (Structured Query Language) is a database query language. According to ANSI, it is the…

Q: List the number of customers living at each state that is included in the Customer_T table.

A: Query:-

Q: Display the RID, RType and Bedroom of all ROOMS whose number of bedrooms is less than RID 105. Use…

A: Required:

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Select lastname, firstname from employeetab,Manager where employeetab.manager_id=Manager.managerid…

A: Answer: We need to explain the SQL code and how it works. so we will see in the more details with…

Q: Write a query to display the book number, title and cost of books that have the lowest cost of any…

A: Query: In general, the term query describes a question or request that is made by a user or another…

Q: SQL List the item number in lower case, description in upper case, order date 30 days later (add 30…

A: ORDER Table:  Creating ORDER table: create table ORDERS(ORDER_NUM integer,ORDER_DATE…

Q: Write the following as the MySQL query:  List the employee ID, first name, last name, hire date,…

A: In database administration, it is frequently essential to extract particular data from a dataset…

Q: 4. Which customers live in Georgia or New Jersey? Put the results in ascending order by last name.…

A: Assume that, the name of the table is Customer The entities of Customer table are last name, first…

Q: Query list of all our customers full name and email. Show those whose customer id is either…

A: The above question is solved in step 2:-

Q: Display the PID and average prices from the PRODUCTS table which price is less than the average…

A: Here we need to perform group by operation in the main query and use Having clause to select only…

Q: Select FirstName,LastName,department,project_name,hours from employeetab,Project where…

A: This SQL code aims to select certain columns from two tables, employeetab and Project, join them…

Q: Determine which orders had a higher total amount due than order 1008.

A: Explanation: The following query determines the orders where the total amount is higher than order…

Q: Only q2 Consider the following customer table and write SQL queries. (Queries should be hand written…

A: We need to write a query for question 2.

Q: Write a query to display the rental number, rental date, movie title, and detail fee for each movie…

A: According to the given schema, first create a table Movies and insert some records in the table.…

Q: Generate a listing of all purchases made by the customers, using the output shown in the following…

A: SQL query The SQL code for sorting the results by invoice number, product description and customer…

Q: 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order.…

A: According to the information given:- We have to follow the instruction in order to perform the…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

A: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

Q: The code: "SELECT SupplierlID FROM Products Order By SupplierName DESC;" extracts data from Products…

A: Sol1: Current procedure terminology (CPT) is a code such as reflex testing and is an integrated part…

Q: For every completed or 'open service request for janitorial work', list the condo id, description,…

A: The querry has given

Q: 4. Determine which orders had a higher total amount due than order 1008. SQL commands

A: SQL is the standardized programming language that is used to manage relational databases and perform…

Q: Write a query to display all vendors sorted by vendor name.   Write a query to display the product…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Find the ID, first name, and last name of each customer whose first name begins with the letter S.

A: The question has been answered in step2: