Based on the stage 2, write queries for the following questions: Sample output are provided for some queries. Write a query to display all vendors sorted by vendor name. Write a query to display the product id, description, type, base, category, and price for all products that have a product base of water and a product category of sealer. Write a query to display the first name, last name, and email address of employees who were not hired from January 1, 2015, to December 31, 2019. Sort the output by last name and then by first name. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 123 and have the title “Assistant.” Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date. Write a query to display the first name, last name, street no, street name, city, state, and zip code of any customer who purchased a Forest brand between July 15, 2015, and Jul 20, 2015. If a customer purchased more than one such product, display the customer’s information only once in the output. Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title does not end in the word ”Assistant". CUSTOMERPK CUS_CODECuS FNAMEcus LNAMECUS STREET NOCUS STREET NAMECUs CITYCUS STATECUs ZIPCUS_BALANCEPRODUCTPlacsePK PRODUCT IDPRODUCT DESCRIPTIONPROD TYPEINVOICEPK INV NUMPROD_BASEBRANDSALESPROD CATEGORYPK BRAND IDCUS CODEPK INV NUMPROD PRICEBRAND NAMEINV DATEgenerated+ FK PROD_IDHasPROD QTY ONHANDINV_TOTALBRAND TYPEBRAND IDHas-EMPLOYEE IDBRAND NAMEBRAND TYPECompletesHasEMPLOYEEPK EMP NUMINVENTORYEMP_FNAMEРк PRODUCT DEMP LNAMEFK VEND_IDEMP EMAILEMP_PHONEEMP HIREDATEEMP_TITLEEMP COMISSIONDEPT NUMContainsDEPT NAMEBelongaVENDORPK VEND IDDEPARTMENTPK DEPT_NUMVEND NAMEDEPT NAMEVEND STREET_NOVEND STREET NAMEVEND_CITYVEND STATE

As per our guidelines we are supposed to answer only one question. Kindly repost other questions as…

Answered: Based on the stage 2, write queries for…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

Based on the stage 2, write queries for the following questions: Sample output are provided for some queries.

Write a query to display all vendors sorted by vendor name.

Write a query to display the product id, description, type, base, category, and price for all products that have a product base of water and a product category of sealer.

Write a query to display the first name, last name, and email address of employees who were not hired from January 1, 2015, to December 31, 2019. Sort the output by last name and then by first name.

Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 123 and have the title “Assistant.”

Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.

Write a query to display the first name, last name, street no, street name, city, state, and zip code of any customer who purchased a Forest brand between July 15, 2015, and Jul 20, 2015. If a customer purchased more than one such product, display the customer’s information only once in the output.

Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title does not end in the word ”Assistant".

Transcribed Image Text:CUSTOMER PK CUS_CODE CuS FNAME cus LNAME CUS STREET NO CUS STREET NAME CUs CITY CUS STATE CUs ZIP CUS_BALANCE PRODUCT Placse PK PRODUCT ID PRODUCT DESCRIPTION PROD TYPE INVOICE PK INV NUM PROD_BASE BRAND SALES PROD CATEGORY PK BRAND ID CUS CODE PK INV NUM PROD PRICE BRAND NAME INV DATE generated + FK PROD_ID Has PROD QTY ONHAND INV_TOTAL BRAND TYPE BRAND ID Has- EMPLOYEE ID BRAND NAME BRAND TYPE Completes Has EMPLOYEE PK EMP NUM INVENTORY EMP_FNAME Рк PRODUCT D EMP LNAME FK VEND_ID EMP EMAIL EMP_PHONE EMP HIREDATE EMP_TITLE EMP COMISSION DEPT NUM Contains DEPT NAME Belonga VENDOR PK VEND ID DEPARTMENT PK DEPT_NUM VEND NAME DEPT NAME VEND STREET_NO VEND STREET NAME VEND_CITY VEND STATE

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title does not end in the word ”Assistant".

Solution

by Bartleby Expert

SEE SOLUTION