SQL Queries for ADP interview questions

queries.sql

#Show Mariopa County Database
SELECT * FROM maricopa;

#Show Pima County Database
SELECT * FROM pima;

#Combine Maricopa and Pima databases
SELECT maricopa_id AS cumulative_id, party, age, gender FROM maricopa
UNION
SELECT pima_id as cumulative_id, party, age, gender FROM pima;

#Show everyone in the state Database (SoS)
SELECT * FROM state;

#Find number of Democrats
SELECT COUNT(party) AS Dems FROM state 
WHERE party='D';

#Find number of repulicans
SELECT COUNT(party) AS Reps FROM state
WHERE party='R';