Logical Operators Workbook Question 1 Table name: Pets ID PetName Type 1 Molly Dog 2 Bentley Dog 3 Monica Cat 4 Hammy Hamster Write an SQL query to extract all of the records from the above table. Select* from Pets Question 2 Table name: TVSoaps ID SoapName Channel 1 Eastenders BBC1 2 Coronation Street ITV1 3 Emmerdale Farm ITV1 4 Holby City BBC1 Write an SQL query to extract all of the records from the above table. Select* from TVsoaps Question 3 Table name: Pets ID PetName Type 1 Molly Dog 2 Bentley Dog 3 Monica Cat 4 Hammy Hamster Write an SQL query to extract the records for dogs from the table above. Select* from dog Question 4 Which record ID numbers would have been returned by this query? 1 and 2 Question 5 Write an SQL query to extract the record for Bentley from the Pets table Select* from id 2 Question 6 Table name: TVSoaps ID SoapName Channel 1 Eastenders BBC1 2 Coronation Street ITV1 3 Emmerdale Farm ITV1 4 Holby City BBC1 Write an SQL query to extract the records for BBC1 from the table above. Select* from BBC 1 Question 7 Which record ID numbers would have been returned by this query? 1 AND 4 Question 8 Write an SQL query to extract the record for Eastenders from the table above. Select* from eastenders Question 9 Which record(s) would be extracted if you ran the following SQL query: SELECT * FROM TVSoaps WHERE Channel = ‘BBC2’ Question 10 Table name: Pets ID PetName Type 1 Molly Dog 2 Bentley Dog 3 Monica Cat 4 Hammy Hamster Write an SQL query to extract all of the records which are not dogs. Select* from all except dogs Question 11 Which record IDs would have been returned by this query? 3 and 4 Question 12 Table name: Pets ID PetName Type 1 Molly Dog 2 Bentley Dog 3 Monica Cat 4 Hammy Hamster Write an SQL query to extract all of the records except Monica. Select* from all except monica Question 13 Table name: Pets ID PetName Type 1 Molly Dog 2 Bentley Dog 3 Monica Cat 4 Hammy Hamster Write an SQL query to extract all of the records from this table except ID 4. Select* from all except id 4 Question 14 Table name: TVSoaps ID SoapName Channel 1 Eastenders BBC1 2 Coronation Street ITV1 3 Emmerdale Farm ITV1 4 Holby City BBC1 Write an SQL query to extract all of the records which are not BBC1. Select* from all except BBC1 Question 15 Which record IDs would have been returned by this query? 2 AND 3 Question 16 Table name: TVSoaps ID SoapName Channel 1 Eastenders BBC1 2 Coronation Street ITV1 3 Emmerdale Farm ITV1 4 Holby City BBC1 Write an SQL query to extract all of the records except Holby City. Select* from all except HOLBY CITY Question 17 Table name: TVSoaps ID SoapName Channel 1 Eastenders BBC1 2 Coronation Street ITV1 3 Emmerdale Farm ITV1 4 Holby City BBC1 Write an SQL query to extract all of the records from this table except ID 2. Select* from row ID 2 Question 18 Table name: Pets ID PetName Type Age 1 Molly Dog 1 2 Bentley Dog 4 3 Monica Cat 8 4 Hammy Hamster 2 Write an SQL query to extract all of the records from this table for animals that are older than 3. Select* from all animals older then 3+ Question 19 Which record IDs would have been returned by this query? 2 and 3 Question 20 Table name: Pets ID PetName Type Age 1 Molly Dog 1 2 Bentley Dog 4 3 Monica Cat 8 4 Hammy Hamster 2 Write an SQL query to extract all of the records from this table for animals that are less than 7. Select* from all animals less than 7 Question 21 Which record IDs would have been returned by this query? 1,2 and 4 Question 22 Table name: Pets ID PetName Type Age 1 Molly Dog 1 2 Bentley Dog 4 3 Monica Cat 8 4 Hammy Hamster 2 Write an SQL query to extract all of the records from this table for animals that are 4 years or older. Select* from all animals older then 4+ Question 23 Which record IDs would have been returned by this query? 2 and 3 Question 24 Table name: Pets ID Show More
