Scribd
Upload
177 views5 pages

SQL Customer Table Assignment

The document describes SQL assignments involving creating a customer table with specified columns, inserting 5 records into the table, selecting only the first and last name columns, and selecting records where the first name starts with G and the city is San Jose.

Uploaded by

Vishnu Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
177 views5 pages

SQL Customer Table Assignment

The document describes SQL assignments involving creating a customer table with specified columns, inserting 5 records into the table, selecting only the first and last name columns, and selecting records where the first name starts with G and the city is San Jose.

Uploaded by

Vishnu Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 5

SQL Module 2 Assignemt

Presented by: Singaraju Vishnu Sharma


Email: svishnu231143@gmail.com
1. Create a customer table which comprises of these columns – ‘customer_id’, ‘first_name’, ‘last_name’, ‘email’, ‘address’,
‘city’,’state’,’zip’

We have created the Customer_Table Successfully.


2. Insert 5 new records into the table

3. Select only the ‘first_name’ & ‘last_name’ columns from the customer table
4. Select those records where ‘first_name’ starts with “G” and city is ‘San Jose’

You might also like