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)
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...
Related questions
Question
100%
The second attachment is the data from the nfl
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
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY