Question: Write a single SQL statement for each of the following queries. USE ONLY select, from, where, count. DO NOT USE Having or Group by with
Write a single SQL statement for each of the following queries.
USE ONLY select, from, where, count.
DO NOT USE Having or Group by with count.
Tables:
agent table has -> agent_id | first | middle | last | address | city | country | salary | clearance_id language table has -> lang_id | language languagerel table has -> lang_id | agent_id mission table has -> mission_id | name | access_id | team_id | mission_status securityclearance table has ->; sc_id | sc_level | description skill table has -> skill_id | skill skillrel table has -> skill_id | agent_id team table has -> team_id | name | meeting_frequency teamrel table has - > team_id | agent_id
Questions: 1. What are the team ID and the meeting frequency for the Cyclone team? 2. Which countries have agents with Presidential or Majestic clearance? (Your query shouldnt depend on what clearance IDs are used for these clearance levels, just the names of the levels.) 3. What are the ids and last names of all agents with at least two skills? (You can do this without COUNT.) 4. List the name and status of all missions that have at least one agent who speaks Russian. Dont repeat missions in your result. 5. Which pairs of agents have the same first and last names? (List each pair only once.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
