CREATE VIEW s5_marksheet3 AS
SELECT 
    s.id AS id,
    s.first_name AS first_name,
    s.last_name AS last_name,
    
    math.Mathematics AS mtc1,
    math2.math2 AS mtc2,
    
    phy.physics AS phy1,
    phy2.phy2 AS phys2,
    phy3.phy3 AS phy3,
    
    chem.chemistry AS chem1,
    chem2.chem2 AS chem2,
    chem3.chem3 AS chem3,
    
    bio.biology AS bio1,
    bio2.bio2 AS bio2,
    bio3.bio3 AS bio3,
    
    gp.gp AS gp,
    
    ict.ict AS ict1,
    ict2.ict2 AS ict2,
    
    ent.ent AS ent,
    ent2.ent2 AS ent2,
    ent3.ent3 AS ent3,
    
    art.art AS art1,
    art2.art2 AS art2,
    art3.art3 AS art3,
    art4.art4 AS art4,
    art5.art5 AS art5,
    art6.art6 AS art6,
    
    geo.geography AS geo1,
    geo2.geo2 AS geo2,
    geo3.geo3 AS geo3,
    
    hist.hist AS hist1,
    hist2.hist2 AS hist2,

 
    
    kisw.kiswahili AS kisw1,
    kisw2.kisw2 AS kisw2,
     kisw3.kisw3 AS kisw3,
     
    lug.luganda AS lug1,
    lug2.lug2 AS lug2,
    lug3.lug3 AS lug3,
    
    cre.cre AS cre,
    div2.div2 AS div2,
    div3.div3 AS div3,
    
    submath.submath AS submath,
    
     td.td AS td,
     td2.td2 AS td2,
     td3.td3 AS td3,
     
     lit.lit AS lit1,
    lit2.lit2 AS lit2,
    lit3.lit3 AS lit3,
    
    econ1.econ1 AS econ1,
    econ2.econ2 AS econ2,
    
     agric1.agric1 AS agric,
    agric2.agric2 AS agric2
   
FROM 
    user s
LEFT JOIN 
    math_marks math ON s.id = math.id
LEFT JOIN 
    s5_math2_marks math2 ON s.id = math2.id
LEFT JOIN 
    s4_phy_marks phy ON s.id = phy.id
LEFT JOIN 
    s5_phy2_marks phy2 ON s.id = phy2.id
LEFT JOIN 
    s5_phy3_marks phy3 ON s.id = phy3.id
LEFT JOIN 
    s4_chem_marks chem ON s.id = chem.id
LEFT JOIN 
    s5_chem2_marks chem2 ON s.id = chem2.id
LEFT JOIN 
    s5_chem3_marks chem3 ON s.id = chem3.id
LEFT JOIN 
    s4_bio_marks bio ON s.id = bio.id
LEFT JOIN 
    s5_bio2_marks bio2 ON s.id = bio2.id
LEFT JOIN 
    s5_bio3_marks bio3 ON s.id = bio3.id
LEFT JOIN 
    s5_gp_marks gp ON s.id = gp.id
LEFT JOIN 
    s4_art_marks art ON s.id = art.id
LEFT JOIN 
    s5_art2_marks art2 ON s.id = art2.id
LEFT JOIN 
    s5_art3_marks art3 ON s.id = art3.id
LEFT JOIN 
    s5_art4_marks art4 ON s.id = art4.id
LEFT JOIN 
    s5_art5_marks art5 ON s.id = art5.id
LEFT JOIN 
    s5_art6_marks art6 ON s.id = art6.id
LEFT JOIN 
    s4_geo_marks geo ON s.id = geo.id
LEFT JOIN 
    s5_geo2_marks geo2 ON s.id = geo2.id
LEFT JOIN 
    s5_geo3_marks geo3 ON s.id = geo3.id
LEFT JOIN 
    s4_hist_marks hist ON s.id = hist.id
LEFT JOIN 
    s5_hist2_marks hist2 ON s.id = hist2.id
LEFT JOIN 
    s4_kisw_marks kisw ON s.id = kisw.id
    LEFT JOIN 
    s5_kisw3_marks kisw3 ON s.id = kisw3.id
LEFT JOIN 
    s5_kisw2_marks kisw2 ON s.id = kisw2.id
LEFT JOIN 
    s4_lug_marks lug ON s.id = lug.id
LEFT JOIN 
    s5_lug2_marks lug2 ON s.id = lug2.id
    LEFT JOIN 
    s5_lug3_marks lug3 ON s.id = lug3.id
LEFT JOIN 
    s5_ent3_marks ent3 ON s.id = ent3.id
    LEFT JOIN 
    s5_ent2_marks ent2 ON s.id = ent2.id
    LEFT JOIN 
    s4_ent_marks ent ON s.id = ent.id
LEFT JOIN 
    s4_lit_marks lit ON s.id = lit.id
    LEFT JOIN 
    s5_lit2_marks lit2 ON s.id = lit2.id
    LEFT JOIN
    s5_lit3_marks lit3 ON s.id = lit3.id
    LEFT JOIN 
    s4_td_marks td ON s.id = td.id
    LEFT JOIN 
    s5_td2_marks td2 ON s.id = td2.id
    LEFT JOIN 
    s5_td3_marks td3 ON s.id = td3.id

    LEFT JOIN 
    S4_cre_marks cre ON s.id = cre.id
    LEFT JOIN 
    s5_div2_marks div2 ON s.id = div2.id
    LEFT JOIN 
    s5_div3_marks div3 ON s.id = div3.id
     LEFT JOIN 
    s4_ict_marks ict ON s.id = ict.id
      LEFT JOIN 
    s5_ict2_marks ict2 ON s.id = ict2.id
     LEFT JOIN 
    s5_submath_marks submath ON s.id = submath.id
     LEFT JOIN
     s5_econ1_marks econ1 ON s.id= econ1.id
     LEFT JOIN
      s5_econ2_marks econ2 ON s.id= econ2.id
      LEFT JOIN 
      s5_agric1_marks agric1 ON s.id= agric1.id
      LEFT JOIN 
      s5_agric2_marks agric2 ON s.id= agric2.id ORDER BY first_name ASC;