Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question #6 points) Consider the following FRIENDS zabie w awer the following questions. LASSE TIRSD MERCODE PHONE ST HIP 30SDY AL AL BUD MAS BOLER
Question #6 points) Consider the following FRIENDS zabie w awer the following questions. LASSE TIRSD MERCODE PHONE ST HIP 30SDY AL AL BUD MAS BOLER FERRIS FERIENS ALTOR BOSS SIR 1. What is the output of the following SQL statement? SELECT FROM FRIENDS WHERE LASTNAME LIKE "M%; 100 355-3111 IL 22333 200 555-2222 UK 300 555-6666 CO 80212 381 555-6767 LA 23456 345 555-3223 L 23332 911 555-3116 CA 95633 204 555-2345 CT 95633 2. Write a query that returns everyone who lives in Mlinois (11)with a first name of AL 3. What will this query return? SELECT FIRSTNAME FROM FRIENDS WHERE FIRSTNAME = AL' AND LASTNAME BULHER
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started