Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Write four "select" queries that meet the following criteria: 1. Select unique game dates, sorted by date. 2. Select offense and defense teams from games on Thanksgiving day of 2015 (Nov 26), in which a touchdown occurred and yardlinedirection is "OWN"; do not sort the results. 3. Select the first 10 descriptions in which a fumble occurred. 4. Select unique pairs of penalty type and penalty yards for penalty types that are not blank, and order by penalty yards so that the greatest penalty yards is first. Upload your sql file here on Canvas.

Write four "select" queries that meet the following criteria: 1. Select unique game dates, sorted by date. 2. Select offense and defense teams from games on Thanksgiving day of 2015 (Nov 26), in which a touchdown occurred and yardlinedirection is "OWN"; do not sort the results. 3. Select the first 10 descriptions in which a fumble occurred. 4. Select unique pairs of penalty type and penalty yards for penalty types that are not blank, and order by penalty yards so that the greatest penalty yards is first. Upload your sql file here on Canvas.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
100%
The second attachment is the data from the nfl
Attempt 1 Unlimited Attempts Allowed ✓ Details This assignment helps you practice with the SQL "select" query. We'll use a dataset of NFL play-by- play statistics downloaded from NFLsavant.com. You will only query one table, nf1, in the cinf201 database. Write four "select" queries that meet the following criteria: 1. Select unique game dates, sorted by date. 2. Select offense and defense teams from games on Thanksgiving day of 2015 (Nov 26), in which a touchdown occurred and yardlinedirection is "OWN"; do not sort the results. 3. Select the first 10 descriptions in which a fumble occurred. Up: 4. Select unique pairs of penalty type and penalty yards for penalty types that are not blank, and order by penalty yards so that the greatest penalty yards is first. Upload your sql file here on Canvas. Hints: . On delenn, to test your file, run a .sql file like so: mysql cinf201 < assignment1.sql Transferring files to/from delenn: o use scp <source> <dest> sen dnlante@delenn.stetson.edu:./cinf201/assignment1.sal assignment1.sal for example if . < 62°F Clear Submit Assignment Q Search
Transcribed Image Text:Attempt 1 Unlimited Attempts Allowed ✓ Details This assignment helps you practice with the SQL "select" query. We'll use a dataset of NFL play-by- play statistics downloaded from NFLsavant.com. You will only query one table, nf1, in the cinf201 database. Write four "select" queries that meet the following criteria: 1. Select unique game dates, sorted by date. 2. Select offense and defense teams from games on Thanksgiving day of 2015 (Nov 26), in which a touchdown occurred and yardlinedirection is "OWN"; do not sort the results. 3. Select the first 10 descriptions in which a fumble occurred. Up: 4. Select unique pairs of penalty type and penalty yards for penalty types that are not blank, and order by penalty yards so that the greatest penalty yards is first. Upload your sql file here on Canvas. Hints: . On delenn, to test your file, run a .sql file like so: mysql cinf201 < assignment1.sql Transferring files to/from delenn: o use scp <source> <dest> sen dnlante@delenn.stetson.edu:./cinf201/assignment1.sal assignment1.sal for example if . < 62°F Clear Submit Assignment Q Search
AutoSave Off File Paste B7 6 7 Insert Home XCut Copy Format Painter E X ✓ fx A A B с D 1 Gameld GameDate Quarter Minute 2 2.02E+09 9/8/2022 3 2.02E+09 9/8/2022 4 2.02E+09 ######## 5 2.02E+09 ⠀⠀⠀⠀⠀⠀⠀⠀ 2.02E+09 ##====== 2.02E+09 ##====== 8 2.02E+09 #******* 9 2.02E+09 ******** 10 2.02E+09 ######## Ty N 11 2.02E+09 ######## 12 2.02E+09 13 2.02E+09 14 2.02E+09 ******** 15 2.02E+09 ######## 16 2.02E+09 ******** Ready S 2 W Page Layout Calibri 17 2.02E+09 18 2.02E+09 19 2.02E+09 ******** 20 2.02E+09 ******** 21 2.02E+09 ******** 22 2.02E+09 23 2.02E+09 ******** 24 2.02E+09 ******** 25 2.02E+09 ******** 26 2.02E+09 27 2.02E+09 ******** pbp-2022 #t BIU- 1.M Font Fy Alignment Number Styles Clipboard POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. 3 2 1TH 20 E 4 2 2 2 V 2 2 4 1 2 4 4 4 4 2 2 2 3 3 3 3 3 4 4 4 4 * pbp-2022 Formulas Data Review View Help A A Α' Α' $ 11 9/11/2022 4 2₁ 0 10 4 2 2 FL F G H E Second OffenseTe DefenseTe Down 1 0 0 0 1 1 1 1 0 0 0 12 12 11 10 8 14 V 13 13 12 R A A- V 0 51 17 SF 42 17 CHI 0 6 CHI 24 NO 0 0 20 CAR 17 17 CAR 24 38 38 CHI 32 CHI 49 SF 4 SF 20 SF 37 SF 22 17 CHI 37 CHI 18 CHI 40 === E % 5 T G CHI SF SF ATL CLE CLE SF SF CHI CHI CHI CHI SF SF SF ال 6 H 0 0 2 0 1 0 2 3 0 0 3 0 4 0 0 3 4 1 2 3 1 0 2 3 1 0 ab Wrap Text Merge & Center ToGo & 0 7 0 6 0 10 10 0 0 7 7 3 0 0 11 0 12 0 0 6 6 10 4 2 5 0 4 1 10 0 Q Search Search IL J YardLine 100 100 04 94 100 100 Fa 53 100 100 70 67 100 100 85 100 84 100 100 71 71 84 90 * 92 95 100 55 58 74 100 4+ 00 Date 8 $ % 9 K P → ( L SeriesFirstDown 1 1 1 1 9 0 1 0 0 1 1 0 0 0 1 1 0 o 0 0 0 0 0 1 1 1 500 00 1 1 0 ly M Conditional Format as Cell Formatting Table Styles J K P N 0 NextScore Description Team Win O TWO-MIN ie O TIMEOUT 0 0 (10:17) (SH 0 TIMEOUT 0 (2:17) (NO O TWO MIN 0 TWO-MIN 0 (1:06) (SHC 262412 0 (:24) 2-J.W 0 GAME 0 0 END QUAF (1:20) (SHC 0 O TIMEOUT 0 (1:17) 4-E. 0 TIMEOUT 0 TIMEOUT 0 (:38) (SHO 0 (:32) (FIELI 0 (12:49) (SH 0 (12:04) 22- 0 (11:20) (SH 0 (10:37) 22- O TIMEOUT 0 (14:17) (SH 0 (13:37) (St 0 (13:18) (SH O TIMEOUT P Don't show again 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 7 0 7 - 0 0 0 0 0 0 0 9 0 0 0 G S PO 2 Insert Dele V Cells Q
Transcribed Image Text:AutoSave Off File Paste B7 6 7 Insert Home XCut Copy Format Painter E X ✓ fx A A B с D 1 Gameld GameDate Quarter Minute 2 2.02E+09 9/8/2022 3 2.02E+09 9/8/2022 4 2.02E+09 ######## 5 2.02E+09 ⠀⠀⠀⠀⠀⠀⠀⠀ 2.02E+09 ##====== 2.02E+09 ##====== 8 2.02E+09 #******* 9 2.02E+09 ******** 10 2.02E+09 ######## Ty N 11 2.02E+09 ######## 12 2.02E+09 13 2.02E+09 14 2.02E+09 ******** 15 2.02E+09 ######## 16 2.02E+09 ******** Ready S 2 W Page Layout Calibri 17 2.02E+09 18 2.02E+09 19 2.02E+09 ******** 20 2.02E+09 ******** 21 2.02E+09 ******** 22 2.02E+09 23 2.02E+09 ******** 24 2.02E+09 ******** 25 2.02E+09 ******** 26 2.02E+09 27 2.02E+09 ******** pbp-2022 #t BIU- 1.M Font Fy Alignment Number Styles Clipboard POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. 3 2 1TH 20 E 4 2 2 2 V 2 2 4 1 2 4 4 4 4 2 2 2 3 3 3 3 3 4 4 4 4 * pbp-2022 Formulas Data Review View Help A A Α' Α' $ 11 9/11/2022 4 2₁ 0 10 4 2 2 FL F G H E Second OffenseTe DefenseTe Down 1 0 0 0 1 1 1 1 0 0 0 12 12 11 10 8 14 V 13 13 12 R A A- V 0 51 17 SF 42 17 CHI 0 6 CHI 24 NO 0 0 20 CAR 17 17 CAR 24 38 38 CHI 32 CHI 49 SF 4 SF 20 SF 37 SF 22 17 CHI 37 CHI 18 CHI 40 === E % 5 T G CHI SF SF ATL CLE CLE SF SF CHI CHI CHI CHI SF SF SF ال 6 H 0 0 2 0 1 0 2 3 0 0 3 0 4 0 0 3 4 1 2 3 1 0 2 3 1 0 ab Wrap Text Merge & Center ToGo & 0 7 0 6 0 10 10 0 0 7 7 3 0 0 11 0 12 0 0 6 6 10 4 2 5 0 4 1 10 0 Q Search Search IL J YardLine 100 100 04 94 100 100 Fa 53 100 100 70 67 100 100 85 100 84 100 100 71 71 84 90 * 92 95 100 55 58 74 100 4+ 00 Date 8 $ % 9 K P → ( L SeriesFirstDown 1 1 1 1 9 0 1 0 0 1 1 0 0 0 1 1 0 o 0 0 0 0 0 1 1 1 500 00 1 1 0 ly M Conditional Format as Cell Formatting Table Styles J K P N 0 NextScore Description Team Win O TWO-MIN ie O TIMEOUT 0 0 (10:17) (SH 0 TIMEOUT 0 (2:17) (NO O TWO MIN 0 TWO-MIN 0 (1:06) (SHC 262412 0 (:24) 2-J.W 0 GAME 0 0 END QUAF (1:20) (SHC 0 O TIMEOUT 0 (1:17) 4-E. 0 TIMEOUT 0 TIMEOUT 0 (:38) (SHO 0 (:32) (FIELI 0 (12:49) (SH 0 (12:04) 22- 0 (11:20) (SH 0 (10:37) 22- O TIMEOUT 0 (14:17) (SH 0 (13:37) (St 0 (13:18) (SH O TIMEOUT P Don't show again 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 7 0 7 - 0 0 0 0 0 0 0 9 0 0 0 G S PO 2 Insert Dele V Cells Q
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS