Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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

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

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago