SQL

1. How many donors are from each state?

2. Pretend dphone is their pledge amount. Report the number of donors and average of the pledged amount for each state.

3. Rewrite Q2. Display the result from highest to lowest of average pledge amount.

4. Now pretend pledge = dphone *10. report the minmum, maximum and total pledge for each state.

5. Rewrite Q4. Display only those states where total pledge exceeds 90,000. Use having clause

6.) Write your own query that makes use of HAVING clause

DONORNO DLNAME 101 Abrams 102 Aldinger 103 Beckman 104 Berdahl. 105 Borneman. 106 Brock 107 Buyer t 108 Cetinsoy 109 Chisholm 118 Herskowitz 119 Jefts 110 Crowder 111 Dishman 112 Duke 113 Evans 11.4 Frawley 115 Guo 116 H 117 Hays DONORNO DFNAME DPHONE D STATE DCITY SID SNAME. S MAU 987 POIRER F MGT 763 PARKER F FIN 218 RICHARDS M ACC 359 PELNICK F FIN 862 FAGIN M MGT 748 MEGLIN M MGT 506 LEE M FIN 581 LL F MGT 126 ANDERSON MACC 444 LINSTERBOK M CIS 445 MINSTERBOK F CIS 446 NINSTERBOK F CIS 447 OINSTERBOK M CIS SID SEX GPA. Donor Table DPHONE DS DCITY DFNAME 9018 GA London, Louis 1521 GA Paris Dmitry 8247 WA Sao Paulo Gulsen. 8149 WI Sydney Samuel 1888 MD Bombay 2142 AL London Scott 9355 AK New York. Aylin 6346 AZ Rome Girwan 4482 MA Oslo John 6872 MT London. Thomas 8103 ME Oslo Robert 6513 NC Stockholm Anthony 3903 NC Helsinki. Michelle 4939 FL Tokyo Peter 4336 GA Singapore 4785 MN Perth. Todd 6247 MN Moscow John 5369 ND Kabanul John 1352 SD Lima. Cami Null? NOT NULL NUMBER (38) CHAR (15) CHAR (15) NUMBER (4) CHAR (2) CHAR (15) Student Table GPA. Null? NOT NULL CHAR (3) NOT NULL CHAR (10) CHAR (1) CHAR (3) NUMBER (4,2)