data base design and managment

o    Share what you’ve learnt. In this module, you read about querying the database by using  SELECT SQL statement.  In your own words, discuss what a query is.
o    Discuss the topic. Some data in an Employee table is shown in a picture below. Using your own words, describe what each bold and underlined keyword of the following SQL statement is for. Use the data in the table below to help with your answer. Write the data that you expect to be eliminated from the data set.  At least 150 word!!!
SELECT EmpFirst || ‘  ‘ || EmpLast AS “Employee Name”, DateAttended
FROM EMPLOYEE
WHERE Provider = “Red Cross”
ORDER BY EmpID

Leave a Reply

Your email address will not be published. Required fields are marked *