SOLVE FAST PLEASEEE. I WILL GIVE INSTANT LIKE

Question 4 (10 Points] Consider the following relational schema for an online programming platform: Users User ID Username Password Rank Questions Question ID Question title difficulty level description date_posted Submissions User ID Question ID solution status points date Write appropriate SQL queries for the questions below. For each question write a single query: A. Retrieve the question id and title of all questions that was posted last (i.e. has the latest date) [3] B. Retrieve the user id , rank, submitted question id and points of all submissions from highest point to lowest point [4] C. Retrieve the total points of each user for all submissions combined. The query should show user id and total points [3]