Revision history for TrainingPracticeQueries


Revision [54673]

Last edited on 2019-04-04 17:02:57 by JamesW [Added links to answer page]
Additions:
(You can find the answer solutions for these query questions [[PracticeQueriesAnswers here]])
**You can see all the solutions for these queries [[PracticeQueriesAnswers here]]**

Revision [18018]

Edited on 2016-06-30 09:43:04 by JamieWillett [added more queries]
Additions:
7. Display all of the candidates who went to the same university you did.
8. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number, their first and last name, and what degree they received.
9. COUNT the candidates who are running in New Hampshire for the 2016 election.
10. Display all active statewide offices in the commonwealth of Pennsylvania (just the offices, not the people who hold those offices.)
11. Display all the speech_id's from speeches that have been tagged with the Affordable Care Act. Take it a bit further and get the query to get the COUNT of them.
Deletions:
7. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number, their first and last name, and what degree they received.
8. Display all active statewide offices in the commonwealth of Pennsylvania.
9. Display all the speech_id's from speeches that have been tagged with the Affordable Care Act. Take it a bit further and get the query to get the COUNT of them.

Revision [17614]

Edited on 2016-04-20 10:22:11 by JamieWillett [added more beginner queries]
Additions:
__One table queries:__
__Two table queries:__
7. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number, their first and last name, and what degree they received.
Deletions:
7. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number and the degree.

Revision [17613]

Edited on 2016-04-20 10:16:31 by JamieWillett [added more beginner queries]
Additions:
7. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number and the degree.
Deletions:
7. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number and their first and last name.

Revision [17596]

Edited on 2016-04-15 15:47:25 by JamieWillett [added more beginner queries]
Additions:
5. Display the sig_id, address, and URL of the National Rifle Association.
6. Display all the dead people in Admin; include their candidate_id, first name, last name, and state. Order it by state.
7. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number and their first and last name.
8. Display all active statewide offices in the commonwealth of Pennsylvania.
9. Display all the speech_id's from speeches that have been tagged with the Affordable Care Act. Take it a bit further and get the query to get the COUNT of them.
Deletions:
5. Display all the dead people in Admin; include their candidate_id, first name, last name, and state. Order it by state.
6. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number and their first and last name.
7. Display all active statewide offices in the commonwealth of Pennsylvania.
8. Display all the speech_id's from speeches that have been tagged with the Affordable Care Act. Take it a bit further and get the query to get the COUNT of them.

Revision [17594]

Edited on 2016-04-15 15:32:47 by JamieWillett [added more beginner queries]
Additions:
**Beginner:**
2. Display all the quotes in our database. Hint: quotes are collected by bios.
3. Display the tag_id for the Affordable-Care-Act tag.
4. Display the nickname, capital, motto, bird, and flower of New Hampshire.
5. Display all the dead people in Admin; include their candidate_id, first name, last name, and state. Order it by state.
6. Display all degrees that have periods (B.A., M.S., J.D., etc.) in them, also give the candidate's id number and their first and last name.
7. Display all active statewide offices in the commonwealth of Pennsylvania.
8. Display all the speech_id's from speeches that have been tagged with the Affordable Care Act. Take it a bit further and get the query to get the COUNT of them.
**Intermediate:**
1. Display Joe Biden's Issue Positions.
2. Display all the members of West Virginia's House Rules Committee.
3. Display the **number of** candidates who are in West Virginia's House Rules Committee.
4. Display all of the members of New York Senate's committees in order of committee name.
5. Display all active members of state legislative leadership (Minority Whip, Majority Leader, Speaker, etc.) in Delaware.
Deletions:
2. Display Joe Biden's Issue Positions.
3. Display all the members of West Virginia's House Rules Committee.
4. Display the **number of** candidates who are in West Virginia's House Rules Committee.
5. Display all of the members of New York Senate's committees in order of committee name.

Revision [14684]

Edited on 2015-04-07 14:04:18 by MichaelM [formatting corrections]
Additions:
7. From an actual research query: I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):
~- Religion
~- Professional Experience
~- Top Industries & Sectors behind campaign contributions
~- National Journal - Conservative on Social Policy Score
~- National Journal - Conservative on Economic Policy Score
**[[Practice7 Example of how to build query for question 7]]**
Deletions:
7. From an actual research query:
I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):
Religion
Professional Experience
Top Industries & Sectors behind campaign contributions
National Journal - Conservative on Social Policy Score
National Journal - Conservative on Economic Policy Score

**[[Practice7 Example of how to build query for question 7]]**


Revision [9666]

Edited on 2013-08-27 12:09:34 by MichaelM [formatting corrections]
Additions:
1. Display all of the candidates who are "Christian".
2. Display Joe Biden's Issue Positions.
3. Display all the members of West Virginia's House Rules Committee.
4. Display the **number of** candidates who are in West Virginia's House Rules Committee.
5. Display all of the members of New York Senate's committees in order of committee name.
6. Find all candidates who ran for IL State Senate in 2010; include whether or not they won; list those who won first.
7. From an actual research query:
Deletions:
1. Find all candidates who ran for IL State Senate in 2010; include whether or not they won; list those who won first.
2. Display the **number of** candidates who are "Christian".
3. Display all of Joe Biden's Issue Positions.
4. Display all the members of West Virginia's House Rules Committee.
5. Display the **number of** candidates who are in West Virginia's House Rules Committee.
6. Display all of the members of New York Senate's committees in order of committee name.
7. From an actual research query:

Revision [9428]

Edited on 2013-07-16 10:54:31 by SarkP [formatting corrections]
Additions:
7. From an actual research query:
I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):
Deletions:
7. From an actual research query: I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):

Revision [9421]

Edited on 2013-07-09 15:19:10 by SarkP [formatting corrections]
Additions:
2. Display the **number of** candidates who are "Christian".
Deletions:
2. Display the **number of** candidates who are "Christian."

Revision [8080]

Edited on 2013-03-18 13:06:28 by KristenVicedomini [formatting corrections]
Additions:
----
Fun to test your SQLLZ
http://www.w3schools.com/sql/default.asp

Revision [7637]

Edited on 2013-02-05 14:09:04 by JasonChow [formatting corrections]
Additions:
7. From an actual research query: I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):
Religion
Professional Experience
Top Industries & Sectors behind campaign contributions
National Journal - Conservative on Social Policy Score
National Journal - Conservative on Economic Policy Score
**[[Practice7 Example of how to build query for question 7]]**
Deletions:
7. From an actual research query: I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):
Religion
Professional Experience
Top Industries & Sectors behind campaign contributions
National Journal - Conservative on Social Policy Score
National Journal - Conservative on Economic Policy Score
**[[Practice7 Example of how to build query for question 7]]**

Revision [7636]

Edited on 2013-02-05 14:06:26 by JasonChow [formatting corrections]
Additions:
7. From an actual research query: I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):
Religion
Professional Experience
Top Industries & Sectors behind campaign contributions
National Journal - Conservative on Social Policy Score
National Journal - Conservative on Economic Policy Score
**[[Practice7 Example of how to build query for question 7]]**
Deletions:
7. I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):
Religion
Professional Experience
Top Industries & Sectors behind campaign contributions
National Journal - Conservative on Social Policy Score
National Journal - Conservative on Economic Policy Score
**[[Practice7 Example of how to build query for question 7]]**

Revision [7620]

Edited on 2013-02-05 12:41:12 by JasonChow [formatting corrections]
Additions:
**[[Practice7 Example of how to build query for question 7]]**
Deletions:
**[[Practice7 Example of how to build query]]**

Revision [7521]

Edited on 2013-01-07 08:44:42 by JasonChow [formatting corrections]
Additions:
**[[Practice7 Example of how to build query]]**
Deletions:
**[[Example of how to build query Practice7]]**

Revision [7520]

Edited on 2013-01-07 08:33:25 by JasonChow [formatting corrections]
Additions:
**[[Example of how to build query Practice7]]**
Deletions:
**Example of how to build query**

Revision [7519]

Edited on 2013-01-07 08:31:03 by JasonChow [formatting corrections]
Additions:
7. I'm preparing a chart for Bloomberg Businessweek on the incoming 113th Congress and I would love to get some data from you. Specifically - for each member of the incoming congress (when available):
Deletions:
7. I'm preparing a chart for Bloomberg Businessweek on the incoming 113th
Congress and I would love to get some data from you. Specifically -
for each member of the incoming congress (when available):

Revision [7518]

Edited on 2013-01-07 08:30:29 by JasonChow [formatting corrections]
Additions:
6. Display all of the members of New York Senate's committees in order of committee name.
7. I'm preparing a chart for Bloomberg Businessweek on the incoming 113th
Congress and I would love to get some data from you. Specifically -
for each member of the incoming congress (when available):
Religion
Professional Experience
Top Industries & Sectors behind campaign contributions
National Journal - Conservative on Social Policy Score
National Journal - Conservative on Economic Policy Score

**Example of how to build query**
Deletions:
6. Display all of the members of New York Senate's committees in order of committee name.

Revision [7497]

Edited on 2012-12-18 15:39:57 by MashaShapiro [formatting corrections]
Additions:
2. Display the **number of** candidates who are "Christian."
5. Display the **number of** candidates who are in West Virginia's House Rules Committee.
6. Display all of the members of New York Senate's committees in order of committee name.
Deletions:
2. Display the number of candidates who are "Christian."
5. Display the number of candidates who are in West Virginia's House Rules Committee.

Revision [7496]

Edited on 2012-12-18 14:57:52 by MashaShapiro [formatting corrections]
Additions:
4. Display all the members of West Virginia's House Rules Committee.
5. Display the number of candidates who are in West Virginia's House Rules Committee.
Deletions:
4. Display all the members of West Virginia's Rules Committee.
5. Display the number of candidates who are in West Virginia's Rules Committee.

Revision [7495]

Edited on 2012-12-18 14:45:48 by MashaShapiro [formatting corrections]
Additions:
2. Display the number of candidates who are "Christian."
4. Display all the members of West Virginia's Rules Committee.
5. Display the number of candidates who are in West Virginia's Rules Committee.
Deletions:
2. Find the number of candidates who are "Christian."

Revision [7493]

Edited on 2012-12-18 14:26:44 by MashaShapiro [formatting corrections]
Additions:
3. Display all of Joe Biden's Issue Positions.

Revision [7492]

Edited on 2012-12-18 14:13:09 by MashaShapiro [formatting corrections]
Additions:
2. Find the number of candidates who are "Christian."
Deletions:
2. Find all candidates who are "Christian."

Revision [7491]

Edited on 2012-12-18 14:12:13 by MashaShapiro [formatting corrections]
Additions:

2. Find all candidates who are "Christian."

Revision [7490]

The oldest known version of this page was created on 2012-12-18 12:24:25 by MashaShapiro [formatting corrections]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki