What's wrong with my SQL code? It doesn't run. The SQL files are in the images attached. Queries should extract the answers directly. Use TopBabyNamesbyState.csv1 and write queries to extract the following information: # Which name in which state and in which year had the highest number of occurrences. # SELECT TopName, state, year from TopBabyNamesbyStatewhere occurences=(select max(occurrences) from TopBabyNamesbyState);# What is the average occurrence of “Jessica” as a top name in the state of CA? #SELECT avg(occurrences)FROM TopBabyNamesbyStateWHERE TopName='Jessica' and state='CA'Group by occurrences, state;# The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. #SELECT topname AS Name, OccurrenceFROM TopBabyNamesbyState where year>=2000 and state='WA' and gender='F'ORDER BYOccurrence DESClimit 3;# Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order. #SELECT topname AS Name, avg(Occurrence)FROM TopBabyNamesbyStateGroup by topnamehaving avg(Occurrence)>1000order by topname ASC; ABi10466 WYM1971 Michael13710467 WYM1972 Michael11310468 WYM1973 Michael11910469 WYM1974 Jason12710470 WYM1975 Michael13110471 WYM1976 Jason12510472 WYM1977 Michael13710473 WYM1978 Michael14510474 WYM1979 Michael15510475 WYM1980 Michael17410476 WYM1981 Joshua16010477 WYM1982 Michael16110478 WYM1983 Michael17110479 WYM1984 Michael14410480 WYM1985 Christopher14210481 WYM1986 Christopher12510482 WYM1987 Michael9410483 WYM1988 Michael9910484 WYM1989 Michael10210485 WYM1990 Michael8310486 WYM1991 Michael8510487 WYM1992 Michael7410488 WYM1993 Tyler9010489 WYM1994 Austin7110490 WYM1995 Joshua6210491 WY1996 TylerM6810492 WYM1997 Jacob5510493 WYM1998 Austin5510494 WYM1999 Michael5210495 WYM2000 Jacob4910496 WYM2001 Jacob4410497 WYM2002 Ethan5210498 WYM2003 Jacob4710499 WYM2004 Michael3410500 WYM2005 Jacob4110501 WYM2006 Ethan4410502 WY2007 James3810503 WYM2008 James4110504 WYM2009 Wyatt4210505 WYM2010 James3610506 WYM2011 William3210507 WYM2012 Liam41 A.BiStateGenderYearTopNameOccurrencesAKF1910 Mary1431911 MaryAKF12AKF1912 Mary5AKF1913 Mary21AKF1914 Mary2271915 MaryAKF23AKF1916 Mary189AK1917 Mary2110AK1918 MaryF2711AKF1919 Mary2212AKF1920 Mary38131921 MaryAKF36141922 MaryAKF2915AK1923 Mary2616AKF1924 Mary4117AKF1925 Mary2418AKF1926 Mary39191927 MaryAKF3020AKF1928 Mary2721AK1929 Mary2522AKF1930 Mary3523AKF1931 Mary41241932 MaryAKF2625AKF1933 Mary2526AKF1934 Mary3127AKF1935 Mary2928AKF1936 Mary3329AK1937 Mary4130AKF1938 Mary3731AKF1939 Mary2832AKF1940 Mary4333AKF1941 Mary4034AKF1942 Mary4335AK1943 Mary4736AKF1944 Mary4237AKF1945 Mary4738AKF1946 Mary4739AKF1947 Mary63401948 MaryAKF7141AK1949 Mary7942AKF1950 Mary719.2.

Input Data : A set of SQL queries To find : Debug the queries for the correctness of the output

What's wrong with my SQL code? It doesn't run. The SQL files are in the images attached. Queries should extract the answers directly. Use TopBabyNamesbyState.csv1 and write queries to extract the following information: # Which name in which state and in which year had the highest number of occurrences. # SELECT TopName, state, year from TopBabyNamesbyState where occurences=(select max(occurrences) from TopBabyNamesbyState); # What is the average occurrence of “Jessica” as a top name in the state of CA? # SELECT avg(occurrences) FROM TopBabyNamesbyState WHERE TopName='Jessica' and state='CA' Group by occurrences, state; # The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. # SELECT topname AS Name, Occurrence FROM TopBabyNamesbyState where year>=2000 and state='WA' and gender='F' ORDER BY Occurrence DESC limit 3; # Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order. # SELECT topname AS Name, avg(Occurrence) FROM TopBabyNamesbyState Group by topname having avg(Occurrence)>1000 order by topname ASC;

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

Related questions

Concept explainers

Question

What's wrong with my SQL code? It doesn't run. The SQL files are in the images attached. Queries should extract the answers directly.

Use TopBabyNamesbyState.csv1 and write queries to extract the following information:

# Which name in which state and in which year had the highest number of occurrences. #
SELECT TopName, state, year from TopBabyNamesbyState
where occurences=(select max(occurrences) from TopBabyNamesbyState);

# What is the average occurrence of “Jessica” as a top name in the state of CA? #
SELECT avg(occurrences)
FROM TopBabyNamesbyState
WHERE TopName='Jessica' and state='CA'
Group by occurrences, state;

# The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. #
SELECT topname AS Name, Occurrence
FROM TopBabyNamesbyState where year>=2000 and state='WA' and gender='F'
ORDER BY
Occurrence DESC
limit 3;

# Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order. #
SELECT topname AS Name, avg(Occurrence)
FROM TopBabyNamesbyState
Group by topname
having avg(Occurrence)>1000
order by topname ASC;

A
Bi
10466 WY
M
1971 Michael
137
10467 WY
M
1972 Michael
113
10468 WY
M
1973 Michael
119
10469 WY
M
1974 Jason
127
10470 WY
M
1975 Michael
131
10471 WY
M
1976 Jason
125
10472 WY
M
1977 Michael
137
10473 WY
M
1978 Michael
145
10474 WY
M
1979 Michael
155
10475 WY
M
1980 Michael
174
10476 WY
M
1981 Joshua
160
10477 WY
M
1982 Michael
161
10478 WY
M
1983 Michael
171
10479 WY
M
1984 Michael
144
10480 WY
M
1985 Christopher
142
10481 WY
M
1986 Christopher
125
10482 WY
M
1987 Michael
94
10483 WY
M
1988 Michael
99
10484 WY
M
1989 Michael
102
10485 WY
M
1990 Michael
83
10486 WY
M
1991 Michael
85
10487 WY
M
1992 Michael
74
10488 WY
M
1993 Tyler
90
10489 WY
M
1994 Austin
71
10490 WY
M
1995 Joshua
62
10491 WY
1996 Tyler
M
68
10492 WY
M
1997 Jacob
55
10493 WY
M
1998 Austin
55
10494 WY
M
1999 Michael
52
10495 WY
M
2000 Jacob
49
10496 WY
M
2001 Jacob
44
10497 WY
M
2002 Ethan
52
10498 WY
M
2003 Jacob
47
10499 WY
M
2004 Michael
34
10500 WY
M
2005 Jacob
41
10501 WY
M
2006 Ethan
44
10502 WY
2007 James
38
10503 WY
M
2008 James
41
10504 WY
M
2009 Wyatt
42
10505 WY
M
2010 James
36
10506 WY
M
2011 William
32
10507 WY
M
2012 Liam
41

A.
Bi
State
Gender
Year
TopName
Occurrences
AK
F
1910 Mary
14
3
1911 Mary
AK
F
12
AK
F
1912 Mary
5
AK
F
1913 Mary
21
AK
F
1914 Mary
22
7
1915 Mary
AK
F
23
AK
F
1916 Mary
18
9
AK
1917 Mary
21
10
AK
1918 Mary
F
27
11
AK
F
1919 Mary
22
12
AK
F
1920 Mary
38
13
1921 Mary
AK
F
36
14
1922 Mary
AK
F
29
15
AK
1923 Mary
26
16
AK
F
1924 Mary
41
17
AK
F
1925 Mary
24
18
AK
F
1926 Mary
39
19
1927 Mary
AK
F
30
20
AK
F
1928 Mary
27
21
AK
1929 Mary
25
22
AK
F
1930 Mary
35
23
AK
F
1931 Mary
41
24
1932 Mary
AK
F
26
25
AK
F
1933 Mary
25
26
AK
F
1934 Mary
31
27
AK
F
1935 Mary
29
28
AK
F
1936 Mary
33
29
AK
1937 Mary
41
30
AK
F
1938 Mary
37
31
AK
F
1939 Mary
28
32
AK
F
1940 Mary
43
33
AK
F
1941 Mary
40
34
AK
F
1942 Mary
43
35
AK
1943 Mary
47
36
AK
F
1944 Mary
42
37
AK
F
1945 Mary
47
38
AK
F
1946 Mary
47
39
AK
F
1947 Mary
63
40
1948 Mary
AK
F
71
41
AK
1949 Mary
79
42
AK
F
1950 Mary
71
9.
2.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.