Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Aided Database Design

Authors: Antonio Albano, Valeria De Antonellis, A. Di Leva

1st Edition

0444877355, 978-0444877352

More Books

Students also viewed these Databases questions