Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest amount for Sales Emp #Last Name1001 Johnson1002 O'Malley1003 Vang1004 Lipton1005 Verccino1006 Wong1007 Pernau1008 Morales1009 Su1010 MuellerFirst NameWalterJimSusanPeggyVitoNancyPerrinePedroMelissaFriedrich▼Native Count Department -USAIrelandChinaCanadaItalyJapanFranceMexicoSouth KoreaGermanyPrinters.NotebooksNetworksDesktopsWirelessPrintersNotebooksNetworksDesktopsWirelessSales$125,000$227,000$451,000$132,000$365,000$521,000$378,000$238,000$412,000$225,000Projection Sales$137,500$249,700$496,100$145,000$401,500$573,000$415,800$261,800$453,200$247,500▼

Answered: Create a list showing only the…

Engineering

Computer Science

Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest amount for Sales

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

Similar questions

2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted by each vendor, who has submitted more than one invoice. Order by the number of invoices in descending order. Should return 12 rows. number of vendor name average_invoice_total min_invoice_total max_invoice_total invoices Federal Exoress Corporation United Parcel Service 47 93.15 10.00 739.20 2575.33 1927.54 3813.33 Zvlka Desian Pacific Bel Malov Lithoarachina Inc 313. 55 16.33 867.53 1962. 13 28.50 46.21 23978.48 10976.06 37966, 19 25.67 224.00 Roadwav Packaoe Svstem. Ic 4 10.92 6.00 Blue Cross Comouserve Incram Data Reoroductions Corp IBM |Cardinal Business Media. Inc. 188.00 116.00 9.95 9.95 9.95 2 1077.21 579. 42 1575.00 85.31 116.54 10963.66 21842.00 600.06 132.68 1083. 58 90.36 175.00
question 6 please use the picture below to answer the following question Write a SQL statement to define a constraint in the Position table to ensure the column position does not accept duplicates.
For each customer, list the CustomerID and the total number of orders placed in 2015.
Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors' telephone number and address On this day in the suburbs of the city
You are designing a table for the Sales department. You need to include a column that contains each sales total. Which data type should you specify for this column? Select one: a. CHAR b. DATE c. NUMBER d. VARCHAR
5. In the OrderItems table, display a count of the number of products where item_price is greater than or equal to $6, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BRO3 1 rows returned in 0.03 seconds PROD ID Download 4 NUM PROD ID
Write a SELECT statement that uses the ranking functions to rank products by the total quantity sold. Return these columns: The product_name column from the Products table A column named total_quantity that shows the sum of the quantity for each product in the Order_Items table A column named rank that uses the RANK function to rank the total quantity in descending sequence A column named dense_rank that uses the DENSE_RANK function to rank the total quantity in descending sequence
Q. Please write SQL codes to query data from member tables based on below criteria Please write a SELECT statement to display each member’sdata that member_id is an odd number. Please display the result in ascending order of the last_name. The result should be identical to below results: [Screenshot]
code of create table and insert table only please
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
List the names of all customers that have a credit limit of $7,500 or less
Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255) default ‘x’ Hq_phone_number varchar(255) Primary key of company_id (please use constraint format) Unique key of Hq_phone_number (please use constraint format)