Question

id Fname Lname Score 767 783 721 890 875 804 793 714 878 744 779 839 Mcmichaels 801 1 Denton Hanford 2 Lolicia 4 Stacie 5 Kassandra Cox 6 Queenie Martin 8 Sera 9 Bob Earhart Newbiggin Knapp Lowstetter Moore 10 Mel 11 Terance Hiles 14 Osbourne Smail 18 Luvenia Woolery 29 MalvinaMilliron 32 Xavior

1. Given the table above, write an SQL Query that will select only those individuals that scored 800 or higher, sorted by last name in ascending order.

2. Given the table above, write an SQL Query that will add a new entry for John Smith with a score of 834. The field id is auto incrementing.

3. Given the data below, write an SQL Query that will delete any values where the score is below 740.