QUESTION 4 Structured Query Language (TOTAL: 10 MARKS) Structured query language (SQL) allows database users to interrogate data in a database. Required: The New Zealand Police Department created a database to keep records of speeding offenders and their payment for speeding tickets. The relationship window of that database is shown below. You are to examine it and answer the questions that follows: Relationships X 18 Offender Driver License Number First Name Second Name Date of Birth Gender Address City Offender Payment 1 Payment Receipt Driver License Number Date Payment Received Amount received Required: Provide the SQL to retrieve information for the following: i. Only the offenders' Driver License Number and Date of Birth (2 marks) ii. Only the first name and last name of donors whose gender is recorded as female. (3 marks) . iii. The total amount received from each gender. (5 marks) QUESTION 4 Structured Query Language (TOTAL: 10 MARKS) Structured query language (SQL) allows database users to interrogate data in a database. Required: The New Zealand Police Department created a database to keep records of speeding offenders and their payment for speeding tickets. The relationship window of that database is shown below. You are to examine it and answer the questions that follows: Relationships X 18 Offender Driver License Number First Name Second Name Date of Birth Gender Address City Offender Payment 1 Payment Receipt Driver License Number Date Payment Received Amount received Required: Provide the SQL to retrieve information for the following: i. Only the offenders' Driver License Number and Date of Birth (2 marks) ii. Only the first name and last name of donors whose gender is recorded as female. (3 marks) . iii. The total amount received from each gender