Answer: Question 10

For this table

the SQL command to retrieve the record containing the ID value of 35536 is

SELECT * FROM Subscribers WHERE ID = 35536

Breaking this down, the query contains:

• the action command SELECT
• the * wild card symbol that means ‘all fields’ 
• the FROM command identifies the table
• Subscribers, which is the name of the table to be used.
• WHERE is setting up certain conditions for the selection
• ID = 35536 is the condition

When this query runs, it returns the record:

35536  mongoose  Hammy2Y  N