Question: Using Students, evaluate the following SELECT statement: Students Table STUDENT 10 STUDENT NAME DOB GENDER ALLOWANCE STUDENT LEVEL S100 Ahmad Male 45 B.Tech S102 Sara


Using Students, evaluate the following SELECT statement: Students Table STUDENT 10 STUDENT NAME DOB GENDER ALLOWANCE STUDENT LEVEL S100 Ahmad Male 45 B.Tech S102 Sara Female 45 Diploma 01-May-1995 30-Dec-1994 01-Jan-1999 05-Apr-1998 S103 Hisham Male 90 Level 1 S104 Falsal Male 90 Advanced Diploma 5101 Salim 01. Jan. 1999 Male 45 Diploma SELECT DISTINCT(gender) from students; How many rows are going to be displayed in the results? (excluding the heading row) O a. 0 6.5 Oc1 d. 2 Use Customers Table to complete the SQL Update Statement below: ID FIRST_NAME LAST_NAME ADDRESS CITY STATE ZIP PHONE NUMBER 123 Cole Bee Orlando FL 32838 4075558234 456 Zoe Twee Boston 12889 MA 7098675309 Ava William 123 Main Street 1009 Oliver Avenue 1673 Kincheloe Road 3540 Drainer Avenue 1228 Sunny Glen Lane 501 Tigard FL 97223 5034623017 FL Tallahassee 32301 263 8505908425 James Rockwood Henderson FL Ohio 44115 2168752939 286 Sandra Assume that you what to change the zip code to 12123 for the customer id 286. UPDATE customers SET zip= WHERE ID = 97223 | 12123 | 44115 286 Use Customers Table to complete the SQL Update Statement below: ID FIRST NAME LAST_NAME ADDRESS CITY STATE ZIP PHONE NUMBER Zoe MA 12889 Ava 123 Cole Bee 123 Main Street Orlando FL 32838 4075558234 456 Twee 1009 Oliver Avenue Boston 7098675309 501 William 1673 Kincheloe Road Tigard FL 97223 5034623017 263 James Rockwood 3540 Drainer Avenue Tallahassee 32301 286 Sandra Henderson 1228 Sunny Glen Lane Ohio 44115 2168752939 The SQL statement that displays the customer first name and last name for all customers whose first name ends with "e" in the "Customers" table: FL 8505908425 FL SELECT first_name, last name EROM customers WHERE first_name LIKE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
