ORDER Order Orderld - Customerld - Itemld TransactionDate Click 1/15/2014 1/16/2014 1/16/2014 5/1/2014 2 12 3 2 10 4 2 5/1/2014 5/2/2014 5/11/2014 5/12/2014 5/12/2014 5/16/2014 5/27/2014 6/1/2014 6/1/2014 8/1/2014 8/8/2014 15 3 1 6 10 10 19 15 11 11 12 10 13 14 14 16 15 20 8/8/2014 8/12/2014 8/16/2014 8/30/2014 8/30/2014 16 4 17 16 14 18 19 5 11 20 17 679 3. 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: You should create a query that is based on the table Reservations table and that shows the guests…

A: Structured Query Language, abbreviated as SQL, which usually refers to the one it is a…

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: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

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: 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: --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: 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: List the item ID as ITEM_ID and description as ITEM_DESC for all items. The descriptions should…

A: Actually, A database is a collection of information that is organized so that it can be easily…

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: t the title of all books in the same category as books previously purchased by customer 1007. Don’t…

A: Lets see the solution.

Q: Add a column named ON_HAND_VALUE to the NONCAT table. The on-hand value is a seven-digit number with…

A: Alter table : used to modify column, add column/columns, add constraints, drop column, rename, drop…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

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: Write the SQL code that counts the number of assignments ordered for each project. Call this…

A: We have four tables namely: JOB PROJECT EMPLOYEE ASSIGNMENT We wish to write a query that counts…

Q: If you omitted the WHERE clause of an UPDATE or DELETE statements, the query returns an error…

A: Delete statement without WHERE clause will delete all the records of the table and without proper…

Q: Please help with the following: Which of the following queries returns data about students whose…

A: Which of the following queries returns data about students whose Names begin with the letter ’r’ ?…

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: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and…

A: Columns from the property table that have a square footage of more than 1,500 square feet need to be…

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: Using the WHERE clause, filter the invoice table to find the invoices that were dated after March…

A: The question has been answered in step2

Q: Q1) Please write. a query statement from emp table to display deptno 10’s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: Use select statements to create queries that answer the following questions. Only provide the…

A: Queries: 1) SELECT ItemDescription, Price FROM Flower WHERE ItemDescription LIKE '%Bouquet%' AND…

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: The following SQL clause(s) are not permitted to be used in a subquery in the WHERE or HAVING…

A: Multicolumn subqueries cannot use the <, >, <=, >= comparison operators.

Q: Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the…

A: SELECT CONCAT(LastName," ",substring(FirstName,1,1)) as CONTACT, HomePhone as Phone FROM EMPLOYEES…

Q: Please read the instrucitons before posting an answer that someone else has already posted.…

A: The new query is given below without using GROUP_CONCAT

Q: Part II: Complete the following exercise:    Using a subquery, select student first name where the…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

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…