Mariah Mickens21 Yahoo Co X C Zybooks Watch Wwe Raw 7 4 22 4th X Learn Zybooks Com Zybook Dat 210 55753711 Chapter 1 (107.39 KiB) Viewed 49 times
[email protected] X ← → C =zyBooks Watch WWE Raw 7/4/22-4th x learn.zybooks.com/zybook/DAT_210_55753711/chapter/5/section/17 Home My library > DAT 210: Data Programming Languages home > 5.17: LAB - Select horses with logical operators 5.17 LAB - Select horses with logical operators The Horse table has the following columns: • ID - integer, primary key • RegisteredName - variable-length string • Breed-variable-length string • Height - decimal number • BirthDate - date LAB ACTIVITY 5.17.1: LAB - Select horses with logical operators Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date or after January 1, 2020. 411216.1973286.qx3zqy7 1 -- Your SELECT statement goes here 2 Gradebook 31 Main.sql zy Section 5.17-DAT 210: Data P X EzyBooks catalog ? Help/FAQ 0/10 + Load default template... ☐ Mariah Williams + 8 ▼ 2:02 [email protected] Watch WWE Raw 7/4/22-4th X ← → C learn.zybooks.com/zybook/DAT_210_55753711/chapter/5/section/16 =zyBooks Home The Horse table has the following columns: • ID-integer, auto increment, primary key RegisteredName - variable-length string • Breed-variable-length string Height - decimal number My library > DAT 210: Data Programming Languages home > 5.16: LAB - Delete rows from Horse table 5.16 LAB - Delete rows from Horse table • BirthDate - date Delete the following rows: 1. Horse with ID 5. 2. All horses with breed Holsteiner or Paint. 3. All horses born before March 13, 2013. 411216.1973286.qx3zqy7 LAB ACTIVITY 5.16.1: LAB - Delete rows from Horse table 1 -- Your SQL statements goes here 2 DELETE FROM Horse 3 WHERE ID=5; 4 5 DELETE - to delete row from table X 31 Gradebook Main.sql X zy Section 5.16-DAT 210: Data P X EzyBooks catalog 0/10 + ? Help/FAQ e Mariah Williams Load default template... ☐ ✪ 8 ⠀ ▼ 2:02
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!