Fill in the Blank QuestionFill in the blank question.In the statement: SELECT * FROM Customers, the asterisk (*) indicates that the user wants to extract all the columns of data FROM the table.

Question 6Fill in the blank: The SQL clause SELECT * is used to retrieve all data from a particular _____.

In the following piece of SQL code, what does the asterisk (*) represent?

Fill in the Blank QuestionFill in the blank question.A SQL statement is used to ask a question or communicate a request of the _ management system.

In the SQL statement above, what does * indicate?Group of answer choicesIt indicates nothingIt indicates to extract none of the fields from the table to a queryIt indicates to extract * from the table to a queryIt indicates to extract all the fields from the table to a query

Part A - Single and multiple table queries Value: 10% For the first five questions you have to provide your answer in the form of a SQL statement, with description before as necessary. For example: 1. Example Question: Select all columns from the `Customer` table Example Answer: -- This answer will select out all the columns from the Customer table SELECT * from Customer; Questions 1 – 5: 1. List in ascending order the Last Names of all borrowers with Card Number less than 150. 2. What are the records of those loans between 3 June 2014 and 8 Mar 2018? ◦ The output should include the name of the cardholder, and title of the book ◦ List in ascending order by last name and first name 3. Find the total numbers of loans with last name beginning with D through E (including E); include last name beginning with Q as well as Z also. ◦ The output of the above question should be a column containing the sum of all the loan based on the condition in the query, alternatively the output could be a table with columns that has the last name as per the condition in the query condition, also the table contains the list of loans. 4. Find all borrowers for a loan that have the Date-in before 15-March-15 and the Card number between 100 and 300 in Karama or Darwin. ◦ The output for the above question is a list of all borrowers (first name and last name) based on the condition in the query. 5. Find the number of loans, which have been made from each branch? ◦ Note all branches need to be included even those with no loans ◦ The output of the above question is a table containing the list of loans only as per the condition in the query