Question: Consider table sailors(sid, sname, rating, age) where sid is the primary key. Write SQL query for the following question: List all fields of sailors whose
Consider table sailors(sid, sname, rating, age) where sid is the primary key. Write SQL query for the following question: List all fields of sailors whose name contain character 'o'. * (10 Points) rating 7 1 age 45.0 33.0 8 55.5 8 25.5 10 sid sname 22 Dustin 29 Brustus 31 Lubber 32 Andy 58 Rusty 64 Horatio 71 Zorba 74 Horatio 85 Art 95 Bob 100 Rusty 101 Bob 7 35.0 35.0 16.0 10 9 3 35.0 25.5 63.5 3 8 16.0 45.0 5 Consider table sailors(sid, sname, rating, age) where sid is the primary key; Reserves (sid, bid, day) where {sid, bid, day} is the primary key. Write SQL query for the following question: Show the day when Lubber has reserved any boat. *
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
