QUERY #1 count | last_name --------+------------- 132337 | martin 58932 | mason 34238 | miller 32986 | mary 30242 | mitchell 29543 | mcdonald 29375 | meyer 26619 | morris 26410 | mr 26361 | morton 24082 | mann 22831 | morrison 21882 | moss 21504 | manning 20164 | miss 19284 | marshall 17156 | middleton 16714 | merrill 15868 | moody 14859 | michael 14617 | maxwell 13397 | myers 13071 | morse 12464 | mc donald 12337 | mcintyre 11823 | meyers 11571 | milton 11555 | mackay 11527 | matthews 11502 | milne 11382 | munro 11175 | mackenzie 11052 | moses 11004 | mc kinley 10665 | mc lean 10375 | marsh 10303 | mooney 10055 | morley 9852 | moran 9473 | mc kenzie 9408 | march 9276 | mc cormick 9125 | mills 8707 | mortimer 8661 | moor 8483 | maloney 8339 | monday 8082 | mack 8049 | martinez 7956 | mountain 7586 | mayer 6960 | morgan 6953 | maria 6948 | marks 6641 | moir 6629 | malcolm 6584 | mathews 6447 | macdonald 6308 | me 6198 | mead 6101 | mac 5813 | morrill 5732 | mckay 5728 | moulton 5681 | mercer 5504 | merchant 4819 | mc laughlin 4584 | mc carthy 4467 | mallory 4379 | mellor 4360 | mcfarlane 4128 | mark 4065 | masters 3975 | moore 3973 | margaret 3969 | madison 3839 | mackey 3731 | muir 3586 | marion 3526 | muller 3463 | metcalf 3376 | mc dowell 3330 | mckenzie 3310 | melville 3308 | mansfield 3305 | mclean 3290 | mott 3283 | marr 3265 | mcintosh 3205 | mac donald 3156 | maguire 3033 | mcpherson 3005 | major 3004 | manley 2974 | more 2938 | mahoney 2849 | merritt 2827 | mar 2811 | markham 2760 | mil 2609 | maddox 2581 | morison 2500 | mitchel 2436 | manson 2428 | mosher 2318 | mayhew 2305 | mo 2285 | mc clure 2246 | mccarthy 2210 | mc bride 2175 | marriott 2028 | marsden 1977 | mc mahon 1923 | magee 1815 | millard 1705 | milligan 1671 | mcleod 1608 | massey 1570 | mc leod 1556 | mcgregor 1500 | moseley 1474 | mcmillan 1443 | mc farland 1396 | mater 1318 | maher 1285 | merrick 1268 | murdock 1212 | meek 1205 | melntyre 1133 | month 1116 | mccormick 1099 | marvin 1094 | meadows 1090 | misses 991 | mentioned 933 | monk 920 | metcalfe 876 | mc connell 753 | malone 672 | ml 658 | menzies (141 rows) QUERY #2 flight_id | passenger_id | first_name | last_name -----------+--------------+------------+------------ 174735 | 5784898 | HUDSON | JACKSON 174735 | 5784899 | FINN | DONALD 174735 | 5784900 | EASTON | CLEVELAND 174735 | 5784901 | CLARK | BUCHANAN 174735 | 5784902 | PARKER | PATRICK 174735 | 5784903 | RYDER | WATTS 174735 | 5784904 | GAGE | MARIA 174735 | 5784905 | EMMA | FREEMAN 174735 | 5784906 | MARGOT | ELIZABETH 174735 | 5784907 | KHALIL | GEORGE 174735 | 5784908 | MIA | SMITH 174735 | 5784909 | GRAYSON | KERR 174735 | 5784910 | JACOB | BIGELOW 174735 | 5784911 | ZOEY | POST 174735 | 5784912 | AARON | WALKER 174735 | 5784913 | KAMILA | NICOLL 174735 | 5784914 | RICHARD | GOLDEN 174735 | 5784915 | CALEB | HOBBS 174735 | 5784916 | DANIEL | DAY 174735 | 5784917 | EDUARDO | HOLMAN 174735 | 5784918 | GABRIELLA | DYKE 174735 | 5784919 | JEREMIAH | WATTS 174735 | 5784920 | OLIVIA | HALL 174735 | 5784921 | OLIVER | CLEVELAND 174735 | 5784922 | HARLOW | HARTLEY 174735 | 5784923 | NOAH | GARDNER 174735 | 5784924 | JAMES | NICHOLLS 174735 | 5784925 | NATHAN | SMITH 174735 | 5784926 | BRONSON | SAUNDERS 174735 | 5784927 | LEON | SHELDON 174735 | 5784928 | SAMUEL | MASON 174735 | 5784929 | KADE | WALKER 174735 | 5784930 | MILLIE | MANSON 174735 | 5784931 | NOAH | BARNES 174735 | 5784932 | MACI | POOLE 174735 | 5784933 | KAMILA | WILCOX 174735 | 5784934 | ZAIRA | EAGLE 174735 | 5784935 | RYAN | REEVES 174735 | 5784936 | JACOB | TURNER 174735 | 5784937 | EVANGELINE | PETERS 174735 | 5784938 | JAYDEN | INSTITUTE 174735 | 5784939 | AMARIS | TURNER 174735 | 5784940 | BETHANY | BARTLETT 174735 | 5784941 | RAUL | MATTHEWS 174735 | 5784942 | JAYDEN | WILLARD 174735 | 5784943 | DIEGO | BROOKS 174735 | 5784944 | JEFFREY | HARTLEY 174735 | 5784945 | BRYAN | LANE 174735 | 5784946 | ALEX | BALDWIN 174735 | 5784947 | BENJAMIN | JOHNSTON 174735 | 5784948 | SEBASTIAN | HARDY 174735 | 5784949 | DYLAN | LEE 174735 | 5784950 | CAYDEN | MARSHALL 174735 | 5784951 | ALICIA | CARVER 174735 | 5784952 | DAMIAN | CONNOR 174735 | 5784953 | MAX | WILLIAMS 174735 | 5784954 | TRISTAN | SECRETARY 174735 | 5784955 | CAMILA | WHITEHOUSE 174735 | 5784956 | BENJAMIN | SMITH 174735 | 5784957 | KADENCE | YOUNG 174735 | 5784958 | DAVID | HAM 174735 | 5784959 | EMILIA | GIBBONS 174735 | 5784960 | GABRIELA | FREEMAN 174735 | 5784961 | SEBASTIAN | LATHAM 174735 | 5784962 | luca | barrett 174735 | 5784963 | LILIA | WHEELER 174735 | 5784964 | DANILO | THOMAS 174735 | 5784965 | HAILEY | WILLIAMS 174735 | 5784966 | MALAKAI | HOBSON 174735 | 5784967 | XIOMARA | ELLIOT 174735 | 5784968 | TOBIAS | ALLISON 174735 | 5784969 | ISABEL | WOOD 174735 | 5784970 | GABRIELLA | NICOLL 174735 | 5784971 | JACOB | WOODRUFF 174735 | 5784972 | ALEXANDER | COLE 174735 | 5784973 | MATTHEW | KANE 174735 | 5784974 | JAYDEN | BROWN 174735 | 5784975 | ALESSANDRO | GRADY 174735 | 5784976 | GRACE | RICHARDSON 174735 | 5784977 | JOEY | CHANDLER 174735 | 5784978 | ROBERTO | HARWOOD 174735 | 5784979 | DYLAN | SHARP 174735 | 5784980 | NIKOLAI | IST 174735 | 5784981 | GIANNA | FOWLER 174735 | 5784982 | NATALIE | DEACON 174735 | 5784983 | JAIRO | SCHOOL 174735 | 5784984 | NOAH | RAY 174735 | 5784985 | LIAM | DUNLOP 174735 | 5784986 | CAMILA | SHOEMAKER 174735 | 5784987 | ZACHARY | BROWN 174735 | 5784988 | LOGAN | SHARP 174735 | 5784989 | NATHAN | FOLEY 174735 | 5784990 | JASON | ROY 174735 | 5784991 | EZRAH | STANLEY 174735 | 5784992 | BRYAN | TO 174735 | 5784993 | AALIYAH | WATSON 174735 | 5784994 | LUCA | HANCOCK 174735 | 5784995 | URIEL | JACKSON 174735 | 5784996 | RODRIGO | BUTLER 174735 | 5784997 | LIAM | SERVICE 174735 | 5784998 | MADISON | PRIEST 174735 | 5784999 | HARRISON | MEYER 174735 | 5785000 | GRACE | BROOK 174735 | 5785001 | CHARLES | HULL 174735 | 5785002 | MAVERICK | WARD 174735 | 5785003 | JASON | MAXWELL 174735 | 5785004 | MARCO | PARKER 174735 | 5785005 | JAXSON | KERR 174735 | 5785006 | CAMILLE | BULL 174735 | 5785007 | RENE | SNYDER 174735 | 5829255 | CHARLES | PETERS 174735 | 5829256 | LUKE | HALL 174735 | 5829257 | LEAH | HAWKINS 174735 | 5829258 | ITZEL | ALLISON 174735 | 5829259 | KOLTON | MALONEY 174735 | 5829260 | THOMAS | HOWARD 174735 | 5829261 | RICHARD | JNO 174735 | 5829262 | STEVEN | SCOTT 174735 | 5829263 | ANGELICA | ROTH 174735 | 5829264 | LIANA | SCHOOL 174735 | 5829265 | AMELIA | GUNN 174735 | 5829266 | AYDEN | HAYES 174735 | 5829267 | OLIVIA | STRANGE 174735 | 5829268 | NOAH | SMITH 174735 | 5829269 | THEODORE | FORD 174735 | 5829270 | KIAN | WILLIAMS 174735 | 5829271 | CAMILLE | SMART 174735 | 5829272 | ZION | POLLARD 174735 | 5829273 | GRAYSON | WOODS 174735 | 5829274 | CARTER | BAILEY 174735 | 5829275 | PRESTON | ANDERSON 174735 | 5829276 | BRADLEY | ROSE 174735 | 5829277 | ZOEY | WAY 174735 | 5829278 | OLIVIA | CURTIS 174735 | 5829279 | PATRICK | LEWIS 174735 | 5829280 | AMELIA | ROWE 174735 | 5829281 | CHLOE | WILLIS 174735 | 5829282 | HEATHER | BROS 174735 | 5829283 | JAVIER | BARCLAY 174735 | 5829284 | OLIVER | WOOD 174735 | 5829285 | june | jacobson 174735 | 5829286 | GAVIN | WILCOX 174735 | 5829287 | HUNTER | WASHINGTON 174735 | 5829288 | AXEL | PI 174735 | 5829289 | CALEB | MARY 174735 | 5829290 | Matias | Woods 174735 | 5829291 | RYKER | GORDON 174735 | 5829292 | ELEANOR | SKINNER 174735 | 5829293 | EZRAH | BROS 174735 | 5829294 | SEBASTIAN | SMITH 174735 | 5829295 | ARLETH | JOY 174735 | 5829296 | MIGUEL | HOWARD 174735 | 5829297 | JAYLEEN | NORTH 174735 | 5829298 | VIOLETA | HOWARD 174735 | 5829299 | KAI | BARRETT 174735 | 5829300 | ANAYA | SMITH 174735 | 5829301 | ADRIAN | BANKS 174735 | 5829302 | JULIAN | HAMLIN 174735 | 5829303 | EDUARDO | SI 174735 | 5829304 | JASON | WEST 174735 | 5829305 | KAI | PETERSON 174735 | 5829306 | IKER | GRANT 174735 | 5829307 | CONNOR | HOWLAND 174735 | 5829308 | RYAN | BARNARD 174735 | 5829309 | NICO | READ 174735 | 5829310 | DRAKE | THOMAS 174735 | 5829311 | GAEL | HYDE 174735 | 5829312 | EMILIANO | MASON 174735 | 5829313 | ABRAHAM | BARRETT 174735 | 5829314 | FRANKIE | BRADFORD 174735 | 5829315 | ASHLEY | BURKE 174735 | 5829316 | ERICK | BANKS 174735 | 5829317 | LEXIE | WIGGINS 174735 | 5829318 | JAYDEN | COUNTY 174735 | 5829319 | RYDER | PECK 174735 | 5829320 | ZAHRA | WELLS 174735 | 5829321 | RYLAN | MIDDLETON 174735 | 5829322 | MACK | BONE 174735 | 5829323 | BRIANA | MAHONEY 174735 | 5829324 | ROBERT | BLACK 174735 | 5829325 | Madalyn | wilcox 174735 | 5829326 | RODRIGO | NUTTALL 174735 | 5829327 | AUDREY | WOODS 174735 | 5829328 | MARIA | DOUGLAS 174735 | 5829329 | RUTH | SHAW 174735 | 5921611 | BRYAN | ARNOLD 174735 | 5921612 | LEILAH | ROSE 174735 | 5921613 | EMILY | BRUCE 174735 | 5921614 | EZRA | HEWITT 174735 | 5921615 | KING | SUTTON 174735 | 5921616 | KIAN | COOLEY 174735 | 5921617 | AARON | CITY 174735 | 5921618 | ADRIAN | GEO 174735 | 5921619 | GAEL | MOODY 174735 | 5921620 | KENZIE | RUSH 174735 | 5921621 | JAYCE | CAR 174735 | 5921622 | FRANKIE | NELSON 174735 | 5921623 | SALVADOR | WELLS 174735 | 5921624 | FABIAN | MEYER 174735 | 5921625 | SYDNEY | LINCOLN (200 rows) QUERY #3 passenger_id | first_name | last_name --------------+-------------+------------ 21 | BROOKS | DUNCAN 22 | JOSUE | SMALL 39 | WESTON | RICHARDSON 50 | SOPHIA | BULL 60 | ELI | JACKSON 136 | DANIEL | DATED 156 | NOAH | SMITH 174 | ESMERALDA | SMITH 240 | CECILIA | PHILIP 248 | ALEXANDER | BARNETT 305 | NATHANIEL | MERRICK 311 | LUKE | RUSSELL 339 | ELI | MARTINEZ 341 | JAYLEEN | SCHOOL 351 | AVERY | WATSON 364 | KARTER | CURRIER 372 | DANTE | DAWES 411 | MIA | FREEMAN 417 | KARINA | ANNA 560 | TYLER | HUDSON 561 | BENJAMIN | NEWTON 692 | JASON | MOIR 700 | AALIYAH | MARION 737 | DANIEL | BRIDGE 744 | BODHI | ORR 782 | JACK | WM 876 | AIDEN | SIMPSON 928 | EMILIANO | WALL 972 | MARK | PHELPS 982 | ANTHONY | TURNER 1095 | JADEN | BLISS 1101 | CHARLOTTE | JOHNSON 1116 | ROBERTO | JAMESON 1151 | GRACE | PRATT 1153 | TRISTAN | WRIGHT 1159 | THOMAS | JOHNSTON 1175 | EMILY | NEWMAN 1195 | JORDYN | TURNER 1232 | JASON | CHAMPION 1259 | EMMA | FAIRBANKS 1261 | LIAM | LIVINGSTON 1276 | PATRICIA | MCINTYRE 1373 | JACOB | HOFFMAN 1410 | LILY | LOVELL 1607 | CHEYENNE | WOOD 1649 | LYLA | MAC 1662 | JORDAN | SWEET 1666 | DANA | STODDARD 1691 | ZAYDEN | MEYERS 1708 | HUNTER | MACKENZIE 1720 | TYLER | JOSEPH 1790 | LENNON | JONES 1861 | WAYLON | SIMPSON 1882 | CARTER | BAILEY 1896 | DYLAN | BENEDICT 1898 | JORGE | PAINE 1956 | NOAH | SMITH 2004 | TROY | MARTINEZ 2039 | JACOB | LONDON 2062 | LINA | TEMPLE 2073 | VINCENT | SMITH 2075 | SEBASTIAN | ROBINSON 2135 | KAIRO | SLADE 2165 | FINN | HURD 2177 | ABIGAIL | RICHARDS 2294 | MIKAYLA | WRAY 2347 | JAMES | HOLLIDAY 2357 | AIDEN | LYNCH 2376 | OLIVIA | THOMAS 2378 | VIVIANA | TATE 2443 | KAMILA | ROWE 2451 | KEVIN | WHITE 2474 | LUCIA | ARNOLD 2642 | MIA | MEYERS 2643 | ALEXANDER | GLOVER 2644 | AVIANNA | JEFFERSON 3284 | ANDY | STEPHENSON 3285 | ANGELICA | GOODRICH 3286 | RAUL | ROCK 3497 | ISABELLE | COUNTY 3498 | CODY | NEWMAN 3499 | LIAM | BIGELOW 3527 | NICHOLAS | WILLIAMS 3528 | ANA | BARNARD 3529 | ANGEL | MARY 3566 | PENELOPE | TURNER 3567 | IVY | HURD 3568 | ZAHRA | HELLER 4080 | ADELINA | BRADBURY 4081 | DEACON | ROSS 4082 | AYLA | HART 4292 | ZARA | PECK 4293 | SEBASTIAN | ROWLEY 4294 | COLTON | CRAWFORD 4406 | LIZBETH | WHITE 4407 | LUCIA | PARSONS 4408 | JASON | FRY 4472 | SOPHIE | PATTERSON 4473 | VALENTINA | BARRON 4474 | ZOEY | PHILIPS 4544 | SAMANTHA | BOYER 4545 | ALONSO | ANDERSON 4546 | MADELINE | CREEK 4706 | STEVEN | SO 4707 | GAVIN | NORTH 4708 | RICARDO | SUN 4781 | Jordan | Bartlett 4782 | STELLA | WICKS 4783 | KEVIN | WOODCOCK 4973 | NIXON | GEORGE 4974 | DYLAN | SMITH 4975 | KENDRA | STUART 5162 | BERNARDO | BROWN 5163 | ARI | DONNELLY 5164 | JASPER | MC CORMICK 5231 | CADEN | AVERY 5232 | LUKAS | THOMAS 5233 | VICTORIA | NAYLOR 5322 | AUSTIN | SMITH 5323 | DIANA | BURNETT 5324 | SEBASTIAN | MORISON 5408 | ELISA | MERRILL 5409 | JAMES | BALLARD 5410 | ISAAC | SPARKS 5651 | darian | Vail 5652 | MAVERICK | WILLIAMS 5653 | GRAYSON | WILCOX 6149 | Madeline | carr 6150 | OLIVIA | NOBLE 6151 | ZION | SULLIVAN 6213 | AMANDA | MARTIN 6214 | MADISON | ZIMMERMAN 6215 | URIEL | ANDREWS 6386 | LOGAN | CAMP 6387 | LUCAS | BECKETT 6388 | EDGAR | SON 7383 | AARON | BUDD 7384 | ADDISON | KENYON 7385 | RILEY | GRAY 7480 | ADA | PARKER 7481 | AYDEN | GALLOWAY 7482 | ZACHARY | LOUIS 7601 | KEYLA | DODGE 7602 | JORGE | RICHARDS 7603 | COLE | FRANK 7825 | MANUEL | BURDICK 7826 | PAYTON | OLIVER 7827 | JUDE | RILEY 7966 | BRANDON | MISS 7967 | JACOB | SINGLETON 7968 | JOANNA | HOWARD 8075 | ISABELLA | HASKELL 8076 | RICHARD | PEARSON 8077 | SAGE | HART 8354 | JOEL | HOOD 8355 | OWEN | WARNER 8356 | ISABELLA | PEASE 8517 | JOSEPHINE | FELLOW 8518 | KAYDEN | JAS 8519 | JASPER | ENGLAND 8603 | LIBERTY | THAYER 8604 | SEBASTIAN | CAMP 8605 | SEBASTIAN | CITY 8633 | JONATHAN | BIGGS 8634 | ZAIRA | SHERMAN 8635 | NATHANAEL | WELCH 8648 | BARON | CLEMENT 8649 | ALEJANDRO | YATES 8650 | DYLAN | ROGERS 8666 | BRADLEY | HUSSEY 8667 | NIXON | HENDERSON 8668 | OLIVER | GIBSON 8693 | weston | martin 8694 | JAYDEN | SIMPSON 8695 | RAFAEL | SMITH 8714 | mateo | Saunders 8715 | JACOB | HALL 8716 | JAYDEN | BROWN 8735 | MAXIMILIANO | JOHNSON 8736 | STEPHEN | ANDREWS 8737 | ALLAN | HARLAN 9232 | JASMINE | FORD 9233 | NOA | LARKIN 9234 | KASEN | DAVIDSON 9431 | DAVID | BALL 9432 | DANIEL | BOYD 9433 | JORGE | BAILEY 9482 | Juliette | watson 9483 | BRIXTON | JONES 9484 | JAKE | FROST 9530 | DYLAN | DAVIES 9531 | SOPHIA | BREWER 9532 | DELILAH | WELLS 9617 | MORGAN | TAYLOR 9624 | GIANNA | HOLT 9625 | FINN | MC KENZIE 9626 | ALEXANDER | HUGHES 9720 | JACOB | STOCKTON 9721 | SERENA | FIRTH 9773 | Alana | Sim (200 rows) QUERY #4 booking_id | booking_name | price | city ------------+-------------------------------+---------+------------- 5224511 | Your flight to Philadelphia | 1999.97 | GLASGOW 3524061 | Your flight to Edinburgh | 1999.90 | BELFAST 3676572 | Your flight to London | 1999.84 | SOUTHAMPTON 4649135 | Your flight to London | 1999.74 | EDINBURGH 5271221 | Your flight to London | 1999.64 | BOURNEMOUTH 5274747 | Your flight to Belfast | 1999.61 | LIVERPOOL 4722796 | Your flight to St. Louis | 1999.50 | GLASGOW 2814338 | Your flight to St. Louis | 1999.47 | BELFAST 3330349 | Your flight to London | 1999.45 | GLASGOW 4926157 | Your flight to Amsterdam | 1999.44 | GLASGOW 5309667 | Your flight to London | 1999.44 | GLASGOW 2822242 | Your flight to San Diego | 1999.28 | BIRMINGHAM 4113419 | Your flight to London | 1999.21 | BELFAST 2983351 | Your flight to Seattle | 1999.12 | BRISTOL 3980078 | Your flight to Bristol | 1999.12 | BELFAST 3725869 | Your flight to Abu Dhabi | 1999.06 | LONDON 4168602 | Your flight to Bristol | 1999.05 | EDINBURGH 4366004 | Your flight to Southampton | 1999.04 | EDINBURGH 5026518 | Your flight to Skopje | 1999.03 | BIRMINGHAM 4122124 | Your flight to Bristol | 1998.98 | BOURNEMOUTH 4168156 | Your flight to Belfast | 1998.91 | LONDON 5266723 | Your flight to London | 1998.81 | EDINBURGH 3186163 | Your flight to London | 1998.76 | BELFAST 4081130 | Your flight to Stockholm | 1998.76 | BIRMINGHAM 4584902 | Your flight to Wroclaw | 1998.76 | BELFAST 5139348 | Your flight to Bristol | 1998.76 | BOURNEMOUTH 3513039 | Your flight to Southampton | 1998.44 | EDINBURGH 5231878 | Your flight to Belfast | 1998.38 | LONDON 4172160 | Your flight to Edinburgh | 1998.25 | LONDON 4387628 | Your flight to Amsterdam | 1998.05 | BELFAST 4357439 | Your flight to London | 1997.72 | SOUTHAMPTON 4625840 | Your flight to San Jose Us | 1997.66 | GLASGOW 4530447 | Your flight to San Antonio | 1997.64 | BIRMINGHAM 4718414 | Your flight to London | 1997.63 | BELFAST 5396048 | Your flight to London | 1997.53 | GLASGOW 3050436 | Your flight to Sacramento | 1997.51 | GLASGOW 5562722 | Your flight to London | 1997.50 | BELFAST 3565930 | Your flight to Glasgow | 1997.38 | BRISTOL 4276200 | Your flight to Poznan | 1997.33 | BIRMINGHAM 4798160 | Your flight to Salt Lake City | 1997.11 | BELFAST 4976943 | Your flight to Edinburgh | 1997.05 | LONDON 4339598 | Your flight to London | 1996.97 | EDINBURGH 5003357 | Your flight to Krakow | 1996.96 | BIRMINGHAM 2855828 | Your flight to Toronto | 1996.95 | GLASGOW 3686106 | Your flight to Southampton | 1996.92 | BELFAST 3292102 | Your flight to Southampton | 1996.90 | LONDON 3306976 | Your flight to Skopje | 1996.82 | BIRMINGHAM 2911815 | Your flight to Bournemouth | 1996.78 | BRISTOL 5263008 | Your flight to Edinburgh | 1996.76 | BRISTOL 4916168 | Your flight to Krakow | 1996.71 | BIRMINGHAM 4840854 | Your flight to Edinburgh | 1996.57 | LONDON 5557832 | Your flight to St. Louis | 1996.49 | BRISTOL 2997083 | Your flight to Southampton | 1996.37 | GLASGOW 5007515 | Your flight to London | 1996.32 | EDINBURGH 3268706 | Your flight to Toronto | 1996.22 | GLASGOW 3473962 | Your flight to London | 1996.20 | BELFAST 4016277 | Your flight to Athens | 1996.17 | BIRMINGHAM 4172168 | Your flight to Edinburgh | 1996.11 | LONDON 3676571 | Your flight to London | 1996.10 | SOUTHAMPTON 4947176 | Your flight to Southampton | 1996.01 | EDINBURGH 4788912 | Your flight to Belfast | 1995.95 | BIRMINGHAM 3035311 | Your flight to Belfast | 1995.77 | BIRMINGHAM 3893530 | Your flight to Amsterdam | 1995.76 | GLASGOW 3693137 | Your flight to Edinburgh | 1995.59 | SOUTHAMPTON 5611806 | Your flight to San Francisco | 1995.55 | GLASGOW 5299397 | Your flight to Edinburgh | 1995.53 | SOUTHAMPTON 3343234 | Your flight to Glasgow | 1995.39 | LONDON 4939714 | Your flight to Savannah | 1995.35 | BIRMINGHAM 4226369 | Your flight to Calgary | 1995.34 | GLASGOW 4049098 | Your flight to Marrakech | 1995.30 | BELFAST 2935388 | Your flight to San Diego | 1995.28 | GLASGOW 2897581 | Your flight to Amsterdam | 1995.26 | GLASGOW 2917767 | Your flight to San Jose Us | 1995.26 | GLASGOW 4160415 | Your flight to London | 1995.13 | EDINBURGH 5295276 | Your flight to Toronto | 1995.10 | GLASGOW 4269624 | Your flight to Phoenix | 1995.00 | BRISTOL 3305923 | Your flight to San Jose | 1994.96 | BIRMINGHAM 3190796 | Your flight to London | 1994.85 | GLASGOW 3422591 | Your flight to Belfast | 1994.78 | LONDON 3489286 | Your flight to London | 1994.64 | EDINBURGH 4320330 | Your flight to Warsaw | 1994.62 | BIRMINGHAM 5391533 | Your flight to London | 1994.51 | BELFAST 3226387 | Your flight to Glasgow | 1994.50 | SOUTHAMPTON 5328179 | Your flight to San Antonio | 1994.50 | BRISTOL 3355593 | Your flight to Poznan | 1994.48 | BIRMINGHAM 4587156 | Your flight to Singapore | 1994.35 | BIRMINGHAM 5638417 | Your flight to Glasgow | 1994.34 | LONDON 3698857 | Your flight to Krakow | 1994.22 | BELFAST 2972062 | Your flight to Edinburgh | 1994.19 | LONDON 5195339 | Your flight to London | 1993.78 | SOUTHAMPTON 3506938 | Your flight to Kansas City | 1993.61 | BIRMINGHAM 3711735 | Your flight to Barcelona | 1993.52 | BIRMINGHAM 4667341 | Your flight to London | 1993.52 | SOUTHAMPTON 5147025 | Your flight to Edinburgh | 1993.46 | LONDON 4748801 | Your flight to Edinburgh | 1993.45 | LONDON 4562152 | Your flight to Southampton | 1993.40 | LONDON 4387629 | Your flight to Amsterdam | 1993.38 | BELFAST 4516463 | Your flight to Warsaw | 1993.33 | BELFAST 3667271 | Your flight to Belfast | 1993.28 | BIRMINGHAM 3857098 | Your flight to Calgary | 1993.26 | GLASGOW 3679379 | Your flight to Reno | 1993.25 | GLASGOW 3091562 | Your flight to Amsterdam | 1993.19 | GLASGOW 5613003 | Your flight to Amman | 1992.86 | BIRMINGHAM 5594834 | Your flight to Edinburgh | 1992.65 | LONDON 3060573 | Your flight to Southampton | 1992.52 | GLASGOW 4165749 | Your flight to Amsterdam | 1992.31 | GLASGOW 5203004 | Your flight to Bucharest | 1992.27 | BIRMINGHAM 3021035 | Your flight to Birmingham | 1992.22 | BELFAST 4063312 | Your flight to Athens | 1992.07 | GLASGOW 4168135 | Your flight to Belfast | 1991.97 | LONDON 2816530 | Your flight to Kansas City | 1991.84 | BIRMINGHAM 5611796 | Your flight to Toronto | 1991.83 | GLASGOW 3060567 | Your flight to Southampton | 1991.56 | EDINBURGH 3893535 | Your flight to Amsterdam | 1991.51 | GLASGOW 4472701 | Your flight to Belfast | 1991.44 | LIVERPOOL 4854862 | Your flight to Southampton | 1991.31 | EDINBURGH 3404223 | Your flight to Belfast | 1991.07 | SOUTHAMPTON 5456809 | Your flight to Glasgow | 1991.07 | LONDON 3128325 | Your flight to Belfast | 1990.86 | SOUTHAMPTON 4172155 | Your flight to Edinburgh | 1990.75 | LONDON 5377880 | Your flight to Southampton | 1990.66 | BELFAST 3513066 | Your flight to Southampton | 1990.59 | BELFAST 5203021 | Your flight to Thessaloniki | 1990.44 | BIRMINGHAM 5558900 | Your flight to Accra | 1990.42 | LONDON 3501271 | Your flight to Edinburgh | 1990.40 | LONDON 5555463 | Your flight to London | 1990.36 | SOUTHAMPTON 4892175 | Your flight to Durban | 1990.28 | BIRMINGHAM 4836507 | Your flight to Belfast | 1990.23 | MANCHESTER 3724834 | Your flight to San Jose Us | 1990.19 | GLASGOW 4781031 | Your flight to London | 1990.09 | EDINBURGH 3475250 | Your flight to Southampton | 1990.08 | EDINBURGH 5130725 | Your flight to London | 1990.04 | BELFAST 2816680 | Your flight to Jacksonville | 1989.90 | BIRMINGHAM 4470642 | Your flight to Stockholm | 1989.85 | BIRMINGHAM 3842097 | Your flight to Warsaw | 1989.82 | BELFAST 5443721 | Your flight to London | 1989.72 | EDINBURGH 4538037 | Your flight to Southampton | 1989.70 | BELFAST 3438498 | Your flight to Southampton | 1989.58 | BELFAST 3893538 | Your flight to Amsterdam | 1989.45 | GLASGOW 5428917 | Your flight to Bournemouth | 1989.34 | EDINBURGH 4880762 | Your flight to Belfast | 1989.23 | LONDON 4777105 | Your flight to Bristol | 1989.20 | BELFAST 3745223 | Your flight to Krakow | 1989.14 | BIRMINGHAM 5377851 | Your flight to Southampton | 1989.08 | GLASGOW 3085606 | Your flight to London | 1988.90 | GLASGOW 5086238 | Your flight to Birmingham | 1988.90 | BELFAST 3559708 | Your flight to Belfast | 1988.79 | SOUTHAMPTON 5519104 | Your flight to Riyadh | 1988.78 | BIRMINGHAM 4273829 | Your flight to Warsaw | 1988.66 | BIRMINGHAM 3203160 | Your flight to Edinburgh | 1988.63 | LONDON 4933292 | Your flight to Glasgow | 1988.59 | LONDON 5160870 | Your flight to Southampton | 1988.56 | EDINBURGH 4605035 | Your flight to London | 1988.51 | EDINBURGH 2979264 | Your flight to Sacramento | 1988.44 | BELFAST 2952533 | Your flight to London | 1988.38 | BELFAST 4736872 | Your flight to London | 1988.33 | EDINBURGH 3108759 | Your flight to San Jose Us | 1988.07 | GLASGOW 5147516 | Your flight to Glasgow | 1988.02 | LONDON 5568236 | Your flight to Athens | 1987.96 | BIRMINGHAM 4744641 | Your flight to Belfast | 1987.85 | BIRMINGHAM 5032100 | Your flight to Southampton | 1987.78 | BELFAST 4500414 | Your flight to Belfast | 1987.77 | SOUTHAMPTON 5279024 | Your flight to Edinburgh | 1987.69 | LONDON 5109156 | Your flight to Skopje | 1987.68 | BIRMINGHAM 5484446 | Your flight to Liverpool | 1987.61 | BELFAST 4737430 | Your flight to London | 1987.60 | GLASGOW 2895943 | Your flight to Bristol | 1987.58 | BOURNEMOUTH 3900284 | Your flight to Edinburgh | 1987.22 | LONDON 3105724 | Your flight to Singapore | 1987.11 | BELFAST 4239093 | Your flight to Belfast | 1986.88 | SOUTHAMPTON 4781045 | Your flight to London | 1986.81 | EDINBURGH 4470644 | Your flight to Stockholm | 1986.80 | BIRMINGHAM 4889765 | Your flight to Bournemouth | 1986.64 | LONDON 3632879 | Your flight to Tampa | 1986.55 | BRISTOL 5090563 | Your flight to London | 1986.26 | GLASGOW 3329723 | Your flight to London | 1986.22 | EDINBURGH 2918384 | Your flight to Tulsa | 1986.15 | GLASGOW 4801024 | Your flight to Skopje | 1986.06 | BIRMINGHAM 4435618 | Your flight to Glasgow | 1985.98 | LONDON 5375065 | Your flight to Thessaloniki | 1985.96 | BIRMINGHAM 4847590 | Your flight to Miami | 1985.90 | BIRMINGHAM 3703737 | Your flight to London | 1985.86 | GLASGOW 4160933 | Your flight to London | 1985.77 | GLASGOW 2826612 | Your flight to Accra | 1985.68 | LONDON 4636078 | Your flight to Cairo | 1985.65 | GLASGOW 4862053 | Your flight to Belfast | 1985.63 | SOUTHAMPTON 4926520 | Your flight to Stockholm | 1985.57 | BIRMINGHAM 2814771 | Your flight to Kanpur | 1985.55 | BIRMINGHAM 4666552 | Your flight to Bournemouth | 1985.51 | BRISTOL 5412909 | Your flight to Knoxville | 1985.45 | BELFAST 4520111 | Your flight to Bristol | 1985.42 | EDINBURGH 4858832 | Your flight to Athens | 1985.21 | BIRMINGHAM 2817467 | Your flight to San Juan | 1985.09 | BIRMINGHAM (193 rows) QUERY #5 first_name | last_name | iso_country ------------+------------+------------- TROY | JEWETT | BD CLARISSA | HICKMAN | BD JORGE | COWAN | BD MATTHEW | COLLEGE | BD MADDOX | THOMAS | BD JACOB | FRASER | BD DYLAN | PATERSON | BD LUCAS | HURD | BD GAEL | LYNN | BD GABRIEL | LYONS | BD ALEX | STEVENS | BD JUDITH | SHARPE | BD KARIM | MCINTYRE | BD BRIANNA | HUDSON | BD LOGAN | FREEMAN | BD Natalie | Howe | BD GARY | HALL | BD ATTICUS | REYNOLDS | BD MANUEL | HAROLD | BD MAXWELL | PICKERING | BD AARON | MARY | BD WAYLON | CARR | BD JACK | LAWRENCE | BD JORDYN | WISEMAN | BD JASPER | CHAPLIN | BD LOGAN | PERRY | BD AVA | IRVING | BD AALIYAH | WRIGHT | BD ALEXANDER | CAMERON | BD CONNOR | CARNEY | BD OLIVIA | PARK | BD MIRA | INGALLS | BD NATASHA | WILLIAMS | BD MOLLY | HARTLEY | BD JONATHAN | MILTON | BD JACOB | WOOD | BD DYLAN | SULLIVAN | BD BENTLEY | FOX | BD DAVINA | BASSETT | BD LOGAN | FOLEY | BD SKYLER | FINN | BD DANIEL | LAW | BD JACOB | SUN | BD ABIGAIL | NEWELL | BD VIRGINIA | LEWIS | BD NATHANIEL | DOOLEY | BD ANTHONY | FLEMING | BD LOGAN | LIVINGSTON | BD MATTHEW | MILLER | BD ADA | KERR | BD ALINA | STS | BD BENNETT | HORN | BD ALESSANDRA | HARRISON | BD ALEJANDRO | CALDWELL | BD KILLIAN | GARDNER | BD DANILO | THOMAS | BD CAMILLE | MERRILL | BD ANTHONY | NELSON | BD AMELIA | UNIVERSITY | BD JULIAN | GUNN | BD BRIELLE | ADAMS | BD ANGEL | LONG | BD ARYANNA | MORGAN | BD SEBASTIAN | ADAMSON | BD ALEX | ADAMS | BD AMIRA | GORDON | BD LINCOLN | WM | BD GUSTAVO | WILLIAMS | BD MALAYA | WILLIAMS | BD RONALD | BALDWIN | BD LUKAS | DAVIDSON | BD JACK | HART | BD OLIVER | GRIFFITH | BD JACOB | PHELPS | BD HELEN | LEES | BD KEEGAN | PARKER | BD SCARLETT | JOHNSTON | BD AVA | BLACK | BD JACOB | CLINTON | BD NOAH | SMITH | BD ELI | BENNETT | BD AVA | FLEMING | BD ALESSANDRO | ELLIS | BD JORGE | BUTLER | BD BENNETT | MITCHELL | BD ANTHONY | HOLLIDAY | BD LEVI | SCOTT | BD HANNAH | HALL | BD GRACE | FISHER | BD MONTSERRAT | THOMAS | BD ROME | ANDREWS | BD ROME | ANDREWS | BD LEILA | JAMES | BD LEILA | JAMES | BD ADELINE | DANIEL | BD ADELINE | DANIEL | BD HAZEL | BROOKS | BD HAZEL | BROOKS | BD ZACHARY | ALLAN | BD ZACHARY | ALLAN | BD NATHAN | COHEN | BD NATHAN | COHEN | BD RYAN | BLACK | BD RYAN | BLACK | BD VINCENT | BROWN | BD VINCENT | BROWN | BD CALEB | WATERS | BD CALEB | WATERS | BD RAUL | READ | BD RAUL | READ | BD LILLIAN | MORTON | BD LILLIAN | MORTON | BD ZAYN | ANN | BD ZAYN | ANN | BD JACE | ANDERSON | BD JACE | ANDERSON | BD BODHI | REES | BD BODHI | REES | BD EZEKIEL | SMITH | BD EZEKIEL | SMITH | BD STELLA | TAFT | BD STELLA | TAFT | BD DYLAN | ANDERSON | BD DYLAN | ANDERSON | BD FELIX | MASON | BD FELIX | MASON | BD JASON | KENDALL | BD JASON | KENDALL | BD AVA | SMITH | BD AVA | SMITH | BD ALEXANDER | BROOKE | BD ALEXANDER | BROOKE | BD DANIEL | WARD | BD DANIEL | WARD | BD ROMEO | MASON | BD ROMEO | MASON | BD ALICIA | PLUMMER | BD ALICIA | PLUMMER | BD JAX | HOOPER | BD JAX | HOOPER | BD ARIAN | ALLEN | BD ARIAN | ALLEN | BD DANIEL | FREEMAN | BD DANIEL | FREEMAN | BD KAI | HYDE | BD KAI | HYDE | BD MATEO | JARVIS | BD MATEO | JARVIS | BD JACQUELINE | YEAR | BD JACQUELINE | YEAR | BD EVAN | BRIGHT | BD TRAVIS | COX | BD SEBASTIAN | JOHNSTON | BD MILAN | STEWART | BD Izabella | orr | BD SIERRA | YORK | BD RODRIGO | KELLY | BD AYDEN | MYERS | BD Nathaniel | Tompkins | BD CHARLES | BARTLETT | BD MATEO | ALEXANDER | BD EMILY | WELCH | BD TRISTAN | COUNTY | BD STEPHANIE | UPTON | BD HARRY | NO | BD NOAH | SCOTT | BD JORDAN | LIVINGSTON | BD CAMERON | SMITH | BD NATHAN | SHARP | BD KELSEY | HOLMAN | BD ISAIAH | ROWLAND | BD CHARLES | GRIFFIN | BD PATRICK | LYNCH | BD MAURICIO | DALY | BD LENNON | WATSON | BD THEODORE | CROSS | BD KEVIN | WEIR | BD ABEL | WOOD | BD ELEANOR | CREEK | BD JUNE | ANDERSON | BD juan | mc lean | BD RAUL | PATTERSON | BD ASHLEY | TURNER | BD ALEXANDER | JACKSON | BD JESUS | LORD | BD KALIYAH | DONOVAN | BD NATHAN | LEE | BD JOSE | APPLETON | BD OLIVER | BOYLE | BD MICHAEL | CORPS | BD OWEN | HALL | BD ALEXANDER | SMITH | BD OLIVER | CHURCH | BD JAVIER | AMOS | BD ANDREW | CHAPMAN | BD CHARLOTTE | HOUSTON | BD EMILIA | KENT | BD LUCA | BRIGGS | BD HUDSON | LEWIS | BD MIA | SHEARER | BD (200 rows) QUERY #6 departure_airport | percentage -------------------+-------------------- AAH | 14.743589743589745 ABJ | 17.067307692307693 ABV | 17.482517482517483 ACC | 18.51851851851852 ACT | 10.897435897435898 ADA | 16.025641025641026 ADB | 15.680473372781064 ADD | 16.442307692307693 ADJ | 19.230769230769234 ADL | 19.405594405594407 AEP | 15.705128205128204 AEX | 20.118343195266274 AGA | 10.256410256410255 AGB | 18.58974358974359 AGP | 12.82051282051282 AGR | 14.102564102564102 AGU | 12.82051282051282 AJU | 21.794871794871796 AKC | 17.94871794871795 AKL | 17.277167277167276 ALP | 12.179487179487179 ALY | 17.94871794871795 AMA | 19.230769230769234 AMD | 9.615384615384617 AMI | 19.230769230769234 AMM | 17.97202797202797 AMQ | 19.230769230769234 AMS | 17.39301653977422 ANC | 15.824175824175823 ANK | 11.538461538461538 ANR | 20.51282051282051 AOC | 17.94871794871795 APL | 21.794871794871796 AQP | 12.82051282051282 ARN | 17.88617886178862 ASR | 21.794871794871796 ASU | 16.025641025641026 ATH | 17.692307692307693 ATL | 16.794871794871792 ATQ | 16.538461538461537 AUG | 16.025641025641026 AUH | 17.492394611038677 AUS | 17.256817256817257 AYT | 16.79174484052533 AZD | 7.6923076923076925 AZI | 17.94871794871795 BAD | 16.538461538461537 BAQ | 14.743589743589745 BBI | 12.82051282051282 BBJ | 19.871794871794872 BBU | 18.58974358974359 BCD | 16.666666666666664 BCN | 17.417297728178557 BDJ | 17.307692307692307 BDO | 19.871794871794872 BEL | 17.307692307692307 BEW | 18.803418803418804 BEY | 16.025641025641026 BFH | 19.230769230769234 BFI | 18.681318681318682 BFL | 17.399267399267398 BFM | 12.82051282051282 BFN | 16.666666666666664 BFS | 18.22742474916388 BGA | 20.51282051282051 BGF | 14.743589743589745 BGY | 16.295546558704455 BHD | 20.32967032967033 BHO | 15.384615384615385 BHX | 18.706293706293707 BIF | 17.94871794871795 BJM | 20.51282051282051 BKI | 16.666666666666664 BKK | 17.209432902863558 BKO | 13.736263736263737 BLQ | 13.846153846153847 BLR | 16.38285378743394 BMA | 20.51282051282051 BNA | 17.85343035343035 BND | 18.37606837606838 BNE | 17.02127659574468 BOD | 20.146520146520146 BOG | 17.756410256410255 BOH | 16.208791208791208 BOI | 16.346153846153847 BOS | 17.44876744876745 BPC | 16.666666666666664 BPN | 8.974358974358974 BRE | 16.23931623931624 BRI | 14.957264957264957 BRM | 14.743589743589745 BRO | 13.461538461538462 BRS | 18.509615384615387 BRU | 18.329326923076923 BSB | 17.760180995475114 BTH | 17.307692307692307 BTR | 16.39676113360324 BTZ | 16.666666666666664 BUD | 15.17094017094017 BUF | 16.303099885189436 BUG | 21.794871794871796 BUQ | 14.743589743589745 BUX | 20.51282051282051 BWE | 12.82051282051282 BWI | 17.251131221719458 BWU | 12.82051282051282 BYK | 12.82051282051282 BYU | 19.230769230769234 BZV | 16.025641025641026 CAB | 20.51282051282051 CAI | 16.124260355029584 CAN | 16.95804195804196 CBB | 13.461538461538462 CBQ | 15.384615384615385 CCP | 19.230769230769234 CCS | 17.1875 CDG | 17.46655518394649 CGB | 19.230769230769234 CGH | 14.743589743589745 CGK | 16.99544764795144 CGN | 14.663461538461538 CGO | 16.433566433566433 CGP | 17.307692307692307 CGR | 16.666666666666664 CHA | 17.52136752136752 CIA | 16.95804195804196 CIX | 14.743589743589745 CJB | 18.58974358974359 CJS | 19.230769230769234 CKG | 16.433566433566433 CLE | 17.15550636413946 CLO | 18.58974358974359 CLT | 17.749564351506102 CMB | 14.903846153846153 CMH | 16.483516483516482 CMN | 17.47252747252747 CNF | 16.45299145299145 CNW | 18.58974358974359 COO | 16.923076923076923 COS | 17.51227495908347 CPH | 16.62531017369727 CPT | 19.230769230769234 CRP | 13.461538461538462 CTA | 16.60839160839161 CTG | 16.666666666666664 CTS | 17.467948717948715 CTU | 16.77018633540373 CUC | 18.58974358974359 CUL | 13.782051282051283 CUN | 17.94871794871795 CUU | 16.666666666666664 CVG | 17.437825332562173 CVJ | 17.307692307692307 CWB | 16.895604395604398 DAC | 16.105769230769234 DAL | 18.803418803418804 DAM | 19.230769230769234 DAR | 16.666666666666664 DCA | 16.601752677702045 DEL | 17.701304543409808 DEN | 16.79010267631712 DET | 22.435897435897438 DGO | 15.384615384615385 DJB | 16.666666666666664 DKR | 17.94871794871795 DLA | 17.990074441687344 DLC | 15.33044420368364 DMA | 19.230769230769234 DNZ | 19.230769230769234 DPS | 16.81877444589309 DRS | 18.421052631578945 DSM | 18.0327868852459 DTM | 14.423076923076922 DTW | 16.415163783584834 DUB | 17.6759410801964 DUR | 18.315018315018314 DUS | 18.03076923076923 DXB | 16.73789173789174 DYU | 16.666666666666664 EDF | 17.307692307692307 EDI | 16.307692307692307 EFD | 21.153846153846153 ELP | 15.94551282051282 EME | 16.666666666666664 ENU | 13.461538461538462 EOH | 19.230769230769234 ERF | 12.82051282051282 ESB | 19.070512820512818 ESS | 10.256410256410255 EVN | 15 EWR | 16.8997668997669 FAT | 17.866004962779154 FCO | 19.230769230769234 FDH | 15.384615384615385 FIH | 17.159763313609467 FKI | 17.307692307692307 FLL | 17.113893858079905 FLN | 19.615384615384617 FNA | 15.837104072398189 FNJ | 14.102564102564102 (200 rows) QUERY #7 subject | number | title | section | instructor | enrolled ---------+--------+--------------------------------+---------+----------------------------+---------- CS | 149 | INTRODUCTION TO PROGRAMMING | 0001 | Sprague,Nathan R | 29 CS | 149 | INTRODUCTION TO PROGRAMMING | 0002 | Sprague,Nathan R | 30 CS | 149 | INTRODUCTION TO PROGRAMMING | 0003 | Wang,Isaac Decheng | 30 CS | 149 | INTRODUCTION TO PROGRAMMING | 0004 | Wang,Isaac Decheng | 29 CS | 149 | INTRODUCTION TO PROGRAMMING | 0005 | Mayfield,Christopher Scott | 30 CS | 149 | INTRODUCTION TO PROGRAMMING | 0006 | Mayfield,Christopher Scott | 29 CS | 149 | INTRODUCTION TO PROGRAMMING | 0008 | El Kadi,Mona A | 30 CS | 149 | INTRODUCTION TO PROGRAMMING | 0009 | Chao,Alvin J | 23 CS | 149 | INTRODUCTION TO PROGRAMMING | 0010 | Shrestha,Chandani | 30 CS | 149 | INTRODUCTION TO PROGRAMMING | 0011 | Shrestha,Chandani | 29 CS | 149 | INTRODUCTION TO PROGRAMMING | 0012 | Simmons,Sharon Jeanette | 28 CS | 149 | INTRODUCTION TO PROGRAMMING | 0013 | Simmons,Sharon Jeanette | 30 CS | 159 | ADVANCED PROGRAMMING | 0001 | Duan,Zhuojun | 27 CS | 159 | ADVANCED PROGRAMMING | 0002 | Duan,Zhuojun | 30 CS | 159 | ADVANCED PROGRAMMING | 0003 | Stewart,Michael Clark | 29 CS | 159 | ADVANCED PROGRAMMING | 0004 | Stewart,Michael Clark | 30 CS | 159 | ADVANCED PROGRAMMING | 0005 | Bernstein,David Howard | 30 CS | 159 | ADVANCED PROGRAMMING | 0006 | Mayfield,Christopher Scott | 30 CS | 227 | DISCRETE STRUCTURES I | 0001 | Riley,Philip B | 30 CS | 227 | DISCRETE STRUCTURES I | 0002 | Riley,Philip B | 30 CS | 227 | DISCRETE STRUCTURES I | 0003 | Bhaskar,Siddharth K | 28 CS | 227 | DISCRETE STRUCTURES I | 0004 | Bhaskar,Siddharth K | 30 CS | 227 | DISCRETE STRUCTURES I | 0005 | Fox,Christopher J | 36 CS | 240 | ALGORITHMS AND DATA STRUCTURES | 0001 | Bowers,John C | 29 CS | 240 | ALGORITHMS AND DATA STRUCTURES | 0002 | Bowers,John C | 29 CS | 240 | ALGORITHMS AND DATA STRUCTURES | 0003 | Buchholz,Florian Paul | 33 CS | 240 | ALGORITHMS AND DATA STRUCTURES | 0004 | Buchholz,Florian Paul | 33 CS | 261 | COMPUTER SYSTEMS I | 0001 | Lam,Michael O | 31 CS | 261 | COMPUTER SYSTEMS I | 0002 | Lam,Michael O | 32 CS | 261 | COMPUTER SYSTEMS I | 0003 | El Kadi,Mona A | 30 CS | 261 | COMPUTER SYSTEMS I | 0004 | El Kadi,Mona A | 30 CS | 280 | PROJECTS IN COMPUTER SCIENCE | 0001 | Mayfield,Christopher Scott | 1 CS | 327 | DISCRETE STRUCTURES II | 0001 | Bhaskar,Siddharth K | 30 CS | 327 | DISCRETE STRUCTURES II | 0002 | Wang,Xunhua | 30 CS | 327 | DISCRETE STRUCTURES II | 0003 | Wang,Xunhua | 30 CS | 343 | APPLICATION DEVELOPMENT | 0001 | Kirkpatrick,Michael Scott | 24 CS | 343 | APPLICATION DEVELOPMENT | 0002 | Stewart,Michael Clark | 30 CS | 343 | APPLICATION DEVELOPMENT | 0003 | Stewart,Michael Clark | 30 CS | 345 | SOFTWARE ENGINEERING | 0001 | Bernstein,David Howard | 30 CS | 345 | SOFTWARE ENGINEERING | 0002 | Bernstein,David Howard | 28 CS | 345 | SOFTWARE ENGINEERING | 0003 | Riley,Philip B | 29 CS | 345 | SOFTWARE ENGINEERING | 0004 | Riley,Philip B | 27 CS | 354 | INTRO AUTONOMOUS ROBOTS | 0001 | Sprague,Nathan R | 18 CS | 361 | COMPUTER SYSTEMS II | 0001 | Kirkpatrick,Michael Scott | 31 CS | 361 | COMPUTER SYSTEMS II | 0002 | Kirkpatrick,Michael Scott | 29 CS | 361 | COMPUTER SYSTEMS II | 0003 | Tjaden,Brett Clinton | 30 CS | 412 | APPLIED ALGORITHMS | 0001 | Molloy,Kevin Patrick | 14 CS | 412 | APPLIED ALGORITHMS | 0002 | Molloy,Kevin Patrick | 27 CS | 412 | APPLIED ALGORITHMS | 0003 | Duan,Zhuojun | 16 CS | 430 | PROGRAMMING LANGUAGES | 0001 | Johnson,Christopher R | 22 CS | 430 | PROGRAMMING LANGUAGES | 0002 | Johnson,Christopher R | 24 CS | 432 | COMPILERS | 0001 | Lam,Michael O | 30 CS | 445 | MACHINE LEARNING | 0001 | Molloy,Kevin Patrick | 27 CS | 447 | INTERACTION DESIGN | 0001 | Shrestha,Chandani | 26 CS | 452 | DESIGN & ANALYSIS ALGORITHMS | 0001 | Bowers,John C | 12 CS | 455 | ADV COMP NETWORK | 0001 | Aboutabl,Mohamed Said | 8 CS | 455 | ADV COMP NETWORK | 0002 | Aboutabl,Mohamed Said | 15 CS | 457 | INFORMATION SECURITY | 0001 | Aboutabl,Mohamed Said | 21 CS | 480 | TOPICS IN COMPUTER SCIENCE | 0001 | Wang,Isaac Decheng | 30 CS | 488 | COMPUTER GRAPHICS APPLICATIONS | 0001 | Johnson,Christopher R | 30 (60 rows) QUERY #8 subject | count ---------+------- SCOM | 156 BIO | 150 MATH | 133 COB | 120 HTH | 94 WRTC | 91 HIST | 76 CHEM | 72 KIN | 69 PSYC | 65 CS | 57 ECON | 56 SMAD | 56 NSG | 55 ISAT | 53 ISCI | 53 POSC | 46 PHYS | 45 ELED | 44 ART | 40 MKTG | 39 ENG | 38 MGT | 38 CIS | 37 ENGR | 34 SRM | 34 SOCI | 33 PHIL | 32 MUS | 29 ACTG | 28 FIN | 28 GEOG | 28 HM | 27 REL | 26 GEOL | 24 CSD | 22 LED | 22 SPAN | 22 ARTH | 20 IA | 20 EXED | 19 JUST | 19 MUAP | 19 THEA | 19 DANC | 18 EDUC | 17 BUS | 16 HUM | 16 ITAL | 16 ANTH | 14 HON | 13 MBA | 13 SOWK | 12 IT | 11 MSSE | 11 OT | 11 HRD | 10 MSCI | 10 NUTR | 10 ARCD | 9 CRJU | 9 GRPH | 9 HSA | 9 UNST | 9 LDT | 8 ADSU | 7 ASTR | 5 ECED | 5 FR | 5 IECE | 5 IS | 5 MUED | 5 PA | 5 PPA | 5 AAAD | 4 CHIN | 4 MUI | 4 WGSS | 4 FAM | 3 GER | 3 IPE | 3 LAXC | 3 SRL | 3 STAD | 3 AMST | 2 ATEP | 2 BSAN | 2 ENVT | 2 FL | 2 IB | 2 INDU | 2 INTA | 2 JAPN | 2 KOR | 2 NPS | 2 TCLD | 2 AIRS | 1 BIOT | 1 BLAW | 1 DATA | 1 GERN | 1 GRAD | 1 HUMN | 1 LTLE | 1 TESL | 1 (105 rows) QUERY #9 term | subject | number | suffix | section | room | room_cap | enrolled | enrl_cap ------+---------+--------+--------+---------+--------------------------------+----------+----------+---------- 1201 | CHEM | 336 | L | 0901 | Physics/Chemistry 1258 | 6 | 16 | 16 1201 | CHEM | 336 | L | 0902 | Physics/Chemistry 1258 | 6 | 15 | 16 1201 | MSCI | 100 | | 0001 | Memorial Hall 7365 | 27 | 87 | 100 1201 | MSCI | 102 | | 0001 | Memorial Hall 7350 | 30 | 50 | 51 1201 | MSCI | 102 | | 0001 | Memorial Hall 7365 | 27 | 50 | 51 1201 | MSCI | 102 | | 0002 | Memorial Hall 7365 | 27 | 43 | 50 1201 | MSCI | 200 | | 0001 | Memorial Hall 7365 | 27 | 43 | 100 1201 | OT | 555 | | 0001 | Health & Behavioral St 2037 | 15 | 23 | 24 1201 | OT | 560 | | 0001 | Health & Behavioral St 2037 | 15 | 23 | 25 1201 | OT | 585 | | 0001 | Health & Behavioral St 2037 | 15 | 23 | 25 1201 | OT | 651 | | 0001 | Health & Behavioral St 2037 | 15 | 23 | 25 1201 | OT | 655 | | 0001 | Health & Behavioral St 2037 | 15 | 23 | 25 1201 | OT | 692 | | 0001 | Health & Behavioral St 2037 | 15 | 23 | 25 1201 | OT | 692 | | 0001 | Health & Behavioral St 3031 | 12 | 23 | 25 1201 | OT | 692 | | 0001 | Health & Behavioral St 3043 | 12 | 23 | 25 1201 | PSYC | 210 | | 0001 | Miller Hall 1111 | 15 | 23 | 20 1201 | PSYC | 210 | | 0004 | Miller Hall 1111 | 15 | 23 | 20 1201 | PSYC | 211 | | 0005 | Miller Hall 1111 | 15 | 46 | 54 1201 | PUAD | 606 | | 0001 | Miller Hall 2104 | 12 | 19 | 15 1201 | THEA | 171 | | 0001 | Forbes Estes Center 1207 | 16 | 37 | 38 1201 | THEA | 171 | | 0001 | Forbes Estes Center 1231 | 18 | 37 | 38 1208 | ARCD | 200 | | 0001 | Studio Center 0204 | 18 | 32 | 36 1208 | ART | 392 | | 0001 | Memorial Hall Arts Cmplex 1013 | 8 | 21 | 14 1208 | ENGR | 101 | | 0001 | Engineering/Geosciences 1208 | 40 | 131 | 145 1208 | ENGR | 101 | | 0001 | Engineering/Geosciences 1209 | 55 | 131 | 145 1208 | ENGR | 101 | | 0001 | Engineering/Geosciences 2204 | 48 | 131 | 145 1208 | ENGR | 101 | | 0001 | Engineering/Geosciences 2208 | 40 | 131 | 145 1208 | ENGR | 101 | | 0001 | ISAT/CS Building 0150 | 40 | 131 | 145 1208 | ENGR | 101 | | 0001 | ISAT/CS Building 0350 | 48 | 131 | 145 1208 | ISCI | 101 | | 0003 | Physics/Chemistry 2116 | 20 | 48 | 48 1208 | KIN | 242 | | 0001 | Godwin Hall 0137 | 25 | 50 | 50 1208 | STAD | 171 | | 0001 | Forbes 1220 - Rehearsal Hall | 20 | 36 | 39 1208 | STAD | 171 | | 0001 | Forbes 1231 - Scene Shop | 18 | 36 | 39 1211 | ART | 360 | | 0001 | Memorial Hall Arts Cmplex 1013 | 8 | 20 | 18 1211 | ART | 464 | | 0001 | Memorial Hall Arts Cmplex 1013 | 8 | 17 | 13 1211 | CHEM | 336 | L | 0901 | Physics/Chemistry 1258 | 8 | 19 | 12 1211 | CHEM | 336 | L | 0902 | Physics/Chemistry 1258 | 8 | 19 | 12 1211 | CHEM | 368 | L | 0901 | Physics/Chemistry 1240 | 4 | 8 | 20 1211 | ENGR | 112 | | 0002 | Engineering/Geosciences 1009 | 25 | 38 | 38 1211 | ENGR | 112 | | 0003 | Engineering/Geosciences 1009 | 25 | 38 | 38 1211 | ENGR | 112 | | 0004 | Engineering/Geosciences 1009 | 25 | 38 | 39 1211 | STAD | 171 | | 0001 | Forbes 1209 - Design Classroom | 20 | 57 | 60 1211 | STAD | 171 | | 0001 | Forbes 1215 - Costume Shop | 25 | 57 | 60 1211 | STAD | 171 | | 0001 | Forbes 1231 - Scene Shop | 18 | 57 | 60 1218 | ARCD | 200 | | 0001 | Studio Center 0107 | 18 | 32 | 35 1218 | ARCD | 200 | | 0001 | Studio Center 0204 | 18 | 32 | 35 1218 | ART | 360 | | 0001 | Memorial Hall Arts Cmplex 1013 | 8 | 15 | 14 1218 | ART | 392 | | 0001 | Memorial Hall Arts Cmplex 1013 | 8 | 17 | 18 1218 | DANC | 215 | E | 0002 | Forbes 1270 - Dance Theatre | 25 | 40 | 40 1218 | MATH | 199 | | 0001 | Roop Hall 0127 | 40 | 261 | 325 1218 | STAD | 171 | | 0001 | Forbes 1207 - Light Lab | 16 | 41 | 45 1218 | STAD | 171 | | 0001 | Forbes 1209 - Design Classroom | 20 | 41 | 45 1218 | STAD | 171 | | 0001 | Forbes 1215 - Costume Shop | 25 | 41 | 45 1218 | STAD | 171 | | 0001 | Forbes 1231 - Scene Shop | 18 | 41 | 45 (54 rows) QUERY #10 instructor | students ----------------------------+---------- Riley,Philip B | 649 Stewart,Michael Clark | 548 Lam,Michael O | 534 Molloy,Kevin Patrick | 511 Bowers,John C | 505 Johnson,Christopher R | 484 Sprague,Nathan R | 483 Mayfield,Christopher Scott | 437 Aboutabl,Mohamed Said | 433 Weikle,Dee Ann Burgess | 383 Kirkpatrick,Michael Scott | 382 Buchholz,Florian Paul | 350 Bhaskar,Siddharth K | 330 Wang,Xunhua | 328 Duan,Zhoujun | 327 Bernstein,David H | 315 El Kadi,Mona A | 308 Wang,Isaac Decheng | 307 Shrestha,Chandani | 275 Richards,Kirsten Esther | 262 Simmons,Sharon Jeanette | 219 Bernstein,David Howard | 183 Heydari,Mohammad H | 180 Chao,Alvin J | 162 Tjaden,Brett C. | 124 Duan,Zhuojun | 123 Fox,Christopher J | 96 Tjaden,Brett Clinton | 93 Normand,Allison Paige | 34 Duncan,David Lee | 27 Salman,Ahmad Ali Ali | 25 West,Robert C | 22 El-Tawab,Samy Sayed | 8 West,Robert Charles | 6 Blow,Cartinez | 5 Zhu,Alf | 3 | 2 Salib,Emil Habib | 1 Nischal,Peddiraju V | 0 (39 rows)