Write a query to display the employee number, first name, last name, and largest salary amount for each employee in department 200. Sort the output by largest salary in descending order. Write a query to display the invoice number, line numbers, product SKUs, product descriptions, and brand ID for sales of sealer and top coat products of the same brand on the same invoice. Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee 83677. Sort the output by customer last name and then first nam
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
- Write a query to display the employee number, first name, last name, and largest salary amount for each employee in department 200. Sort the output by largest salary in descending order.
- Write a query to display the invoice number, line numbers, product SKUs, product descriptions, and brand ID for sales of sealer and top coat products of the same brand on the same invoice.
- Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee 83677. Sort the output by customer last name and then first name.
![LGCUSTOMER
LGBRAND
PK Cust Code
PK Brand 1D
Cust_Fname
Cust_Lname
Cust Street
Cust_City
Cust_State
Cust_ZIP
Cust_Balance
Brand_Name
Brand_Type
includes
places
LGPRODUCT
LGLINE
PK
Prod SKU
LGINVOICE
PK,FK1 Inv_Num
Line_Num
Prod_Descript
Prod Type
Prod_Base
Prod_Category
Prod_Price
Prod_QOH
Prod_Min
FK1 Brand_ID
PK
Inv Num
PK
appears on
contains
--
Prod_SKU
Line_Qty
Line_Price
FK1 Cust_Code
FK2
Inv_Date
Inv_Total
FK2 Employee_ID
completes
provided by
LGEMPLOYEE
PK
Emp Num
LGSALARY_HISTORY
LGSUPPLIES
Emp_Fname
Emp_Lname
Emp_Email
Emp_Phone
Emp_Hiredate
Emp_Title
Emp_Comm
FK1 Dept_Num
PK,FK1 Emp_Num
PK
PK,FK1 Vend_ID
PK,FK2 Prod_SKU
has
Sal_From
Sal_End
Sal_Amount
provides
employs
manages
LGVENDOR
PK Vend ID
LGDEPARTMENT
Vend_Name
Vend_Street
Vend_City
Vend_State
Vend_ZIP
PK
Dept_Num
Dept_Name
Dept_Mail_Box
Dept_Phone
FK1 Emp_Num](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F1a03d32b-3970-4ea1-84d1-3c1dc6e45559%2F0e071190-ff20-46e1-aa7e-6c9295f3486c%2Fv7r7u1c_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)