write queries to extract the following information
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:
A list of all columns in this dataset?
How many rows are there in this dataset?
A list of unique names in this dataset ordered alphabetically from A to Z?
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
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