MySQL) The data tables were too long to post here. Q1. Use TopBabyNamesbyState.csv1 and write queries to extract the following information: How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 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. Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.
MySQL) The data tables were too long to post here. Q1. Use TopBabyNamesbyState.csv1 and write queries to extract the following information: How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 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. Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.
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
Related questions
Question
(MySQL) The data tables were too long to post here.
Q1. Use TopBabyNamesbyState.csv1 and write queries to extract the following information:
How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”.
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.
Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.
Transcribed Image Text: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.
Transcribed Image Text: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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
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.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education