Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --fråga 1
- Select * from elevhistorik
- Select elevnamn from elevhistorik where elevnamn like 'a%'
- --fråga 2
- Select * from elevhistorik
- Select count(elev_id) from elevhistorik where årskurs=9 and termin ='VT17'
- --fråga 3
- Select * from betyg
- select * from betyg where month(betygsatt_datum)=6 or month(betygsatt_datum)=12
- --fråga 4
- Select * from elevhistorik
- select * from betyg
- select * from elevhistorik
- RIGHT JOIN betyg
- on elevhistorik.elev_id=betyg.elev_id
- where elevnamn is null
- --fråga 5
- Select * from elevhistorik
- Select * from betyg
- select distinct elevnamn, personnr, kön from elevhistorik
- right join betyg
- on elevhistorik.elev_id=betyg.elev_id
- where ämne='Matematik' and betyg.termin='VT15' and betyg='F' and skola ='Davidshallskolan'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement