6. Write an SQL query to calculate how much each client must pay every week.

"3,4,and 5 are answered"

as per our policy we are only allowed to solve 3 subparts.kindly reupload rest of the question

3 create table

CREATE TABLE table1 (
    day varchar(255),
    client_code varchar(255),
    client_name varchar(255),
    team_ID varchar(255),
    member int,
   team_leader varchar(255),
  leader_wage int,
  total int
);

4.insert data into table

INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  'monday','c4','aeliana gebahard','T3','6','jaymes merrickson','350','850'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c10','alfher dareia','T1','6','geoffrey glover','250','750'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  ' ','c8','felina diodotus','T2','5','elmer victorson','300','700'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c9','brutus sighild','T4','7','norris mamadou','400','1000'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  'tuesday','c5','sigibert quirinus','T3','6','jaymes merrickson','350','850'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c9','brutus sigihild','T2','5','elmer victorson','300','700'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c10','alfher dreia','T5','5','duncan gardyner','450','850'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c7','servius ambrosia','T1','6','geoffrey glover','250','750'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c10','alfher dareai','T2','5','elmer victorson','300','700'); 

INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  'wednesday','c10','alfher dareia','T3','6','jaymes merrickson','350','850'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c1','nikolaos gallus','T4','7','norris mamadou','400','1000'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  ' ','c3','amalia prochoros','T2','5','elmer victorson','300','700'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c8','felina diodotus','T3','6','jaymes merrickson','350','850'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  'thursday','c2','hariwini agrippa','T4','7','norris mamadou','400','1000'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c9','brutus sigihild','T2','5','elmer victorson','300','700'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c5','sigibert quirinus','T2','5','lmer victorson','300','700'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c6','artemisia hippolytos','T3','6','jaymes merrickson','350','850'); 

INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  'friday','c8','felina diodotus','T2','5','elmer victorson','300','700'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c4','aeliana gebahard','T1','6','geoffrey glover','250','750'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  ' ','c9','brutus sigihild','T1','6','elmer victorson','300','700'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
' ','c7','servius ambrosia','T4','7','norris mamadau','400','1000'); 
INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (
  ' ','c2','hariwini agrippa','T3','6','jaymes mrrickson','350','850'); 

5.use a query select * from table1