having difficulty with the following questions. below are the tables.

Post by **answerhappygod** » Sat Nov 27, 2021 2:22 pm

having difficulty with the following questions. below are the
tables.

: Having Difficulty With The Following Questions Below Are The Tables 1 (35.05 KiB) Viewed 73 times

: Having Difficulty With The Following Questions Below Are The Tables 2 (127.27 KiB) Viewed 73 times

: Having Difficulty With The Following Questions Below Are The Tables 3 (281.48 KiB) Viewed 73 times

1. Determine the highest gross pay by the employee in the table [db1]. [costco]-[employee). Use the tables [db1]. [costco].[job], [db1]. [costco].[hours] & [db1]. [costco].[employee]. Format your column with the correct column heading (see solution example) and format the data returned by your query with a leading dollar sign (S), comas every three digits and two decimal places. Query goes here Screen shot goes here 2. Determine the lowest weekly sales from the WEST region. Use the tables, [db1]. [costco].[store_sales], [db1]. [costco].[region]. Format your column with the correct column heading (see solution example) and format the data returned by your query with a leading dollar sign ($), comas every three digits and two decimal places. Query goes here Screen shot goes here 3. Determine the lowest starting bid for any item the [db1]. [costco]. [item] table where the opening bid is in the month of January 2008. Format your column with the correct column heading (see solution example) and format the data returned by your query with a leading dollar sign ($), comas every three digits and two decimal places. Query goes here Screen shot goes here

Costco Employee w 1 2 3 4 EMP_CODE 1 2 3 4 5 5 6 7 8 6 7 9 10 11 8 9 10 11 EMP_TITLE EMP_LNAME Mr. Williamson Ms. Ratula Ms. Greenboro Mrs. Rumpersro Mr. Smith Mr. Renselaer Mr. Ogallo Ms. Johnsson Mr. Eindsmar Jones Mr. Broderick Mr. Washington Mr. Smith Ms. Smith Mr. Olenko Mr. Archialo Ms Grimaldo Mr. Rosenberg Mr. Rosten EMP_FNAME EMP_INITIAL John w Nancy Lottie R Jennie S Robert L Cary А Roberto S Elizabeth 1 Jack W Rose R Tom Alan Y Peter N Sherry H Howard Barry Jeanine K Andrew D Peter F EMP_DOB JOB_CODE STORE_CODE 1964-05-21 SEC 3 1969-09-09 MGR 2 1961-10-02 GEN 4 1971-06-01 GEN 5 1959-11-21 GEN 3 1965-12-25 GEN 1 1962-07-31 MGR 3 1968-09-10 SEC 1 1955-04-19 SEC 2 1966-03-06 GEN 4 1972-10-21 GEN 3 1974-09-08 GEN 2 1964-08-25 GEN 3 1966-05-25 GEN 4 1964-05-24 GEN 5 1960-09-03 GEN 5 1970-11-12 MGR 4 1971-01-24 GEN 4 1968-10-03 GEN 4 Mrs. 12 13 12 13 14 14 15 16 15 16 TO<CI Z 17 17 18 18 19 19 Costco Job Costco hours 1 1 2 JOB_CODE GEN MGR SEC DESCRIPTION BASE_PAY General support 7.50 Manager 37.40 Secretary 18.95 2 emp_code 1 2 3 4 3 3 4 5 6 7 5 6 7 hours 40 40 50 60 20 10 45 55 77 29 32 25 20 60 70 8 8 9 10 11 9 10 11 12 13 14 ಈ 6 ವ ವ = 6 12 13 14 15 15

Costco item winnerld 2 21 24 2 10 1 8 1 1 5 7 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 ino title cid description open DateTime selerld starting Bid bid increment close Date Time 999 Creations of Microbiology 11 Minor Wear and Tear 2008-01-21 p 100 5 1 2008-01-31 1000 Mario Party IV 31 Excellent Condition Best Seller: Super Graphics 2008-04-21 a 100 20 2 2008-04-28 1001 Crustaceans 11 Excellent Condition 2008-02-21 4100 0 2008-02-27 1002 Undersea Livestock 11 Excellent Condition 2008-01-21 s100 2008-02-27 1003 The Imbred Lama Problem 11 Minor Wear and Tear 2008-03-21 m 100 2008-03-31 1004 Eggs and their Formation 11 Great Condition 2008-03-01 p100 10 2008-03-15 1005 Mammals, Mammals and more Mammals 11 Minor Highlighting 2007-11-15 p100 5 2 2007-11-21 1006 Basic Life Forms 11 Minor Wear and Tear 2008-02-29 m 100 2 1 2008-03-05 1007 Interstellar Bacteria 11 some earmarking 2008-03-05 s100 2008-03-21 1008 150 Species of Worms 11 Like New 2008-01-21 3 0 2008-02-01 1009 Insects under 5mm 11 Like New 2008-03-30 5 1 2008-04-06 1010 Oracle 10g Programming: A Primer (Paperback) 12 The Resource for Oracle DB programming. Excellen... 2008-04-03 35 1 2008-04-10 1011 C Programming: A Modem Approach (Paperback) 12 A great introduction to C Programming. Good conditi. 2008-04-05 9100 45 1 2008-04-12 1012 At of Computer Programming, The, Volumes 1-3 Box... 12 Indisputabily the best book for computer algorithms.... 2008-04-05 s100 75 1 2008-04-12 1013 Introduction to MATLAB and Simulink. Third Edition 12 Good condition, small tear in the back cover, Excel... 2008-04-15 m 100 20 0 2008-04-22 1014 UNIX: The Complete Reference. Second Edition 12 Fair condition, some highlighting good Unix resource! 2008-04-14 p100 23 0 2008-04-21 1015 Pro WPF: Windows Presentation Foundation in .NET... 12 Like New!!! Great source for Windows GUI program... 2008-04-13 a 100 2008-04-20 1016 Pro LING: Language Integrated Query in C# 2008 (P... 12 The best book about LINQ so far!! small rip on the c... 2008-04-10 25 2008-04-27 1017 Ajax: The Defintive Guide (Paperback) 12 Excellent reference for AJAX. Tons of examples.Co... 2008-04-09 m 100 27 2008-04-26 p100 m 100 a 100 NULL 1 5 NULL NULL NULL NULL 17 NULL 20 NULL NULL NULL NULL NULL 15 0 4100 1 0 Costco region Row_Number store_Code 1 2 3 1 Costco store STORE_CODE STORE_NAME Access Junction 2 Database Comer 3 Tuple Charge Attribute Alley Primary Key Point 1 2 3 4 5 2 3 лам 1 2 3 4 REGION_CODE DESCRIPT 2 West 3 North 4 South 1 East -UAWN 5 1 4 5 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 5 Costco store sales Weekly_sales region_code 854558.38 1 689475.89 1 978046.91 1 826270.78 1 314859.95 1 402342.82 2 326841.11 2 503921.45 2 949408.97 2 581574.05 2 638178.30 3 511723.79 3 556421.29 3 951686.38 902503.64 3 443410.39 4 281833.15 409222.16 4 853611.42 2 AWNOWNW 5 1 لعبة كما لا ا ه ا ه