CREATE VIEW s5_end_marksheet AS
SELECT 
    s.id AS id,
    s.first_name AS first_name,
    s.last_name AS last_name,
    
    mtc1.mtc1 AS mtc1,
    mtc2.mtc2 AS mtc2,
    
    phy1.phy1 AS phy1,
    phy2.phy2 AS phys2,
  
    
    chem1.chem1 AS chem1,
    chem2.chem2 AS chem2,
    chem3.chem3 AS chem3,
    
    bio1.bio1 AS bio1,
    bio2.bio2 AS bio2,
    bio3.bio3 AS bio3,
    
    gp.gp AS gp,
    
    ict1.ict1 AS ict1,
    ict2.ict2 AS ict2,
    
    ent1.ent1 AS ent,
    ent2.ent2 AS ent2,
    ent3.ent3 AS ent3,
    
    art1.art1 AS art1,
    art2.art2 AS art2,
    art3.art3 AS art3,
    art4.art4 AS art4,
  
    
    geo1.geo1 AS geo1,
    geo2.geo2 AS geo2,
    geo3.geo3 AS geo3,
    
    hist1.hist1 AS hist1,
    hist2.hist2 AS hist2,

 
    
    kisw1.kisw1 AS kisw1,
    kisw2.kisw2 AS kisw2,
     kisw3.kisw3 AS kisw3,
     
    lug1.lug1 AS lug1,
    lug2.lug2 AS lug2,
    lug3.lug3 AS lug3,
    
    div1.div1 AS cre,
    div2.div2 AS div2,
    div3.div3 AS div3,
    
    submath.submath AS submath,
    
     td1.td1 AS td,
     td2.td2 AS td2,
     td3.td3 AS td3,
     
     lit1.lit1 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 
    s5_mtc1_end mtc1 ON s.id = mtc1.id
LEFT JOIN 
    s5_mtc2_end mtc2 ON s.id = mtc2.id
LEFT JOIN 
    s5_phy1_end phy1 ON s.id = phy1.id
LEFT JOIN 
    s5_phy2_end phy2 ON s.id = phy2.id

LEFT JOIN 
    s5_chem1_end chem1 ON s.id = chem1.id
LEFT JOIN 
    s5_chem2_end chem2 ON s.id = chem2.id
LEFT JOIN 
    s5_chem3_end chem3 ON s.id = chem3.id
LEFT JOIN 
    s5_bio1_end bio1 ON s.id = bio1.id
LEFT JOIN 
    s5_bio2_end bio2 ON s.id = bio2.id
LEFT JOIN 
    s5_bio3_end bio3 ON s.id = bio3.id
LEFT JOIN 
    s5_gp_end gp ON s.id = gp.id
LEFT JOIN 
    s5_art1_end art1 ON s.id = art1.id
LEFT JOIN 
    s5_art2_end art2 ON s.id = art2.id
LEFT JOIN 
    s5_art3_end art3 ON s.id = art3.id
LEFT JOIN 
    s5_art4_end art4 ON s.id = art4.id

LEFT JOIN 
    s5_geo1_end geo1 ON s.id = geo1.id
LEFT JOIN 
    s5_geo2_end geo2 ON s.id = geo2.id
LEFT JOIN 
    s5_geo3_end geo3 ON s.id = geo3.id
LEFT JOIN 
    s5_hist1_end hist1 ON s.id = hist1.id
LEFT JOIN 
    s5_hist2_end hist2 ON s.id = hist2.id
LEFT JOIN 
    s5_kisw1_end kisw1 ON s.id = kisw1.id
    LEFT JOIN 
    s5_kisw3_end kisw3 ON s.id = kisw3.id
LEFT JOIN 
    s5_kisw2_end kisw2 ON s.id = kisw2.id
LEFT JOIN 
    s5_lug1_end lug1 ON s.id = lug1.id
LEFT JOIN 
    s5_lug2_end lug2 ON s.id = lug2.id
    LEFT JOIN 
    s5_lug3_end lug3 ON s.id = lug3.id
LEFT JOIN 
    s5_ent1_end ent1 ON s.id = ent1.id
    LEFT JOIN 
    s5_ent2_end ent2 ON s.id = ent2.id
    LEFT JOIN 
    s5_ent3_end ent3 ON s.id = ent3.id
LEFT JOIN 
    s5_lit1_end lit1 ON s.id = lit1.id
    LEFT JOIN 
    s5_lit2_end lit2 ON s.id = lit2.id
    LEFT JOIN
    s5_lit3_end lit3 ON s.id = lit3.id
    LEFT JOIN 
    s5_td1_end td1 ON s.id = td1.id
    LEFT JOIN 
    s5_td2_end td2 ON s.id = td2.id
    LEFT JOIN 
    s5_td3_end td3 ON s.id = td3.id

    LEFT JOIN 
    s5_div1_end div1 ON s.id = div1.id
    LEFT JOIN 
    s5_div2_end div2 ON s.id = div2.id
    LEFT JOIN 
    s5_div3_end div3 ON s.id = div3.id
     LEFT JOIN 
    s5_ict1_end ict1 ON s.id = ict1.id
      LEFT JOIN 
    s5_ict2_end ict2 ON s.id = ict2.id
     LEFT JOIN 
    s5_submath_end submath ON s.id = submath.id
     LEFT JOIN
     s5_econ1_end econ1 ON s.id= econ1.id
     LEFT JOIN
      s5_econ2_end econ2 ON s.id= econ2.id
      LEFT JOIN 
      s5_agric1_end agric1 ON s.id= agric1.id
      LEFT JOIN 
      s5_agric2_end agric2 ON s.id= agric2.id ORDER BY first_name ASC;