Please write SQL and PLSQL statements for the following database

Database: https://codeshare.io/5XKKBj ERD: https://drive.google.com/file/d/0Bzum6VJXi9lUX1d2ZkhudTE3QXc/view?usp=sharing

Query 1: List last names and customer numbers of top 5% of customers for each branch. (Use SUBTOTAL)

Query 2: How much sales each employee (employee number, first name, and last name) has had during each year (Use TOTAL_AMT)

Query 3: Rank top selling products for each product brand (Use QTY)