Please show the output, and must not use JOIN or ON in the queries.

Please don't copy the code from other answers.

Thank you

The list of tables available for this assignment is the following: STORE (StoreID, StoreAddress, WeekDaysHours, WeekendHours) ACCOUNT (AcoountNo., AccountName, Balance) DEPARTMENT (DepartmentID, DepartmentTitle, Noofmployees, AccountNo StoreID, FranchiseTeamID) FRANCHISE APP (AppNumber, AppDate, DecisionDate, Status, DepartmentID, TeamID) EMPLOYEE (EmployeeID, Name, Phone, Email, Address, Gender, DOB, JoiningDate, CentralorLocalEmployment, EFTPOSID, CANumber, DepartmentID) CASUAL EMPLOYEE (EmployeeID, HourlyRate) PART TIME EMPLOYEE (EmployeeID, heeklyHours, Salary) FULL_TIME_EMPLOYEE (EmployeeID, LeaveDays, Salary, MemberID) TEAM MEMBR (MemberID) SHARHOLDER (S,H,ID, Name, Phone, Email, Address, NoOfShares, MemberID) TEAM (TeamID, TeamName, TeamLeaderID) MFMBERSHIP (MemberID, TeamID, Percentageofshare) NoTE: PK is printed underlined and FK is printed italic in italics. Task 1 [50 marks] Using the tables provided above, provide SQL statements for the following queries. a. Show the store information along with its departments for all stores that opens the latest during weekend. b. List the franchise application details for each department of H2H along with the department id and title. Include the departments that have not received any application yet. c. Show the team information and number of members for all suceessful franchise applications. d. Show the details of the franchise application that took the longest time to reach a decision. c. List the team member details (ineluding shareholder and employee details such as id, name, phone and email) for all the team members who are part of a franchise team of a suceessful application. For each of the members, also include the date on which their franchise application was granted. Hint: use UNION. f. List the team member details (member id and team id) who has the maximum eredit to his name, based on his percentage of share in the team and the positive account balance of the franchising department (Hint: account balance can be found in the Account table). Please note, it is safe to assume that only one team member has the highest percentage of share