SQLite Lab 2 Use the lab1.db database from last week’s practical (hint: use the ATTACH command) 1. Display all the records where AGE is greater than or equal to 25 AND salary is greater than or equal...

hi


SQLite Lab 2 Use the lab1.db database from last week’s practical (hint: use the ATTACH command) 1. Display all the records where AGE is greater than or equal to 25 AND salary is greater than or equal to 10000.00. (hint: Use SELECT with a WHERE condition). Take a screenshot and put into your word document. 2. Display all the records where AGE is greater than or equal to 25 OR salary is greater than or equal to 11000.00. Take a screenshot and put into your word document. 3. Display all the records where AGE is not NULL. Take a screenshot and put into your word document. 4. Display all the records where NAME starts with 'Ja', does not matter what comes after 'Ja'. Take a screenshot and put into your word document. 5. Using ‘IN’, display all the records where AGE value is either 24, 32 or 64. Take a screenshot and put into your word document. 6. Using ‘BETWEEN’, display all the records where AGE value is in BETWEEN 25 AND 27. Take a screenshot and put into your word document. 7. Use the UPDATE command and change the ID to 15 in the row where the address is your k-number. 8. DELETE the row from the table where the ID = 7. 9. INSERT a new employee into the table whose name is Adam and is 20 years old, who lives in Cork and has a salary of 15,000. 10. Display all the employees. Take a screenshot and put into your word document. SQLite Lab 2 Use the lab1.db database from last week’s practical (hint: use the ATTACH command) 1. Display all the records where AGE is greater than or equal to 25 AND salary is greater than or equal to 10000.00. (hint: Use SELECT with a WHERE condition). Take a screenshot and put into your word document. 2. Display all the records where AGE is greater than or equal to 25 OR salary is greater than or equal to 11000.00. Take a screenshot and put into your word document. 3. Display all the records where AGE is not NULL. Take a screenshot and put into your word document. 4. Display all the records where NAME starts with 'Ja', does not matter what comes after 'Ja'. Take a screenshot and put into your word document. 5. Using ‘IN’, display all the records where AGE value is either 24, 32 or 64. Take a screenshot and put into your word document. 6. Using ‘BETWEEN’, display all the records where AGE value is in BETWEEN 25 AND 27. Take a screenshot and put into your word document. 7. Use the UPDATE command and change the ID to 15 in the row where the address is your k-number. 8. DELETE the row from the table where the ID = 7. 9. INSERT a new employee into the table whose name is Adam and is 20 years old, who lives in Cork and has a salary of 15,000. 10. Display all the employees. Take a screenshot and put into your word document.