urgent help needed .

answer please

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 Afficulty levd description date posted Submission User ID Quetis ID 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]