1 Write a sql statement to select all rows and columns from

1) Write a sql statement to select all rows and columns from the table Customer:

2) Write a sql statement that returns the Customer’s ID number for those customer’s first name starts with “F”.

3) Write a sql statement to edit all existing records so that the field lastUpdated has today’s date in it within the table CustomerPurchases.

Solution

a)
1)select * from customer;

2)select customers id from customer
where employee_name LIKE \'F%\';