Sorts the resulting set either in an ascending or descending order based on criteria chosen.
Syntax:
-- ORDER BY
SELECT column_1, column_2
FROM table_name
ORDER BY column_1 ASC/DESC;Example: Sort the customers by first name in ascending order.
-- Sort by first_name in ascending order from the customer table
SELECT first_name, last_name
FROM customer
ORDER BY first_name ASC;## first_name last_name
## 1 Aaron Selby
## 2 Adam Gooch
## 3 Adrian Clary
## 4 Agnes Bishop
## 5 Alan Kahn
## 6 Albert Crouse
## 7 Alberto Henning
## 8 Alex Gresham
## 9 Alexander Fennell
## 10 Alfred Casillas
## 11 Alfredo Mcadams
## 12 Alice Stewart
## 13 Alicia Mills
## 14 Allan Cornish
## 15 Allen Butterfield
## 16 Allison Stanley
## 17 Alma Austin
## 18 Alvin Deloach
## 19 Amanda Carter
## 20 Amber Dixon
## 21 Amy Lopez
## 22 Ana Bradley
## 23 Andre Rapp
## 24 Andrea Henderson
## 25 Andrew Purdy
## 26 Andy Vanhorn
## 27 Angel Barclay
## 28 Angela Hernandez
## 29 Anita Morales
## 30 Ann Evans
## 31 Anna Hill
## 32 Anne Powell
## 33 Annette Olson
## 34 Annie Russell
## 35 Anthony Schwab
## 36 Antonio Meek
## 37 April Burns
## 38 Arlene Harvey
## 39 Armando Gruber
## 40 Arnold Havens
## 41 Arthur Simpkins
## 42 Ashley Richardson
## 43 Audrey Ray
## 44 Austin Cintron
## 45 Barbara Jones
## 46 Barry Lovelace
## 47 Beatrice Arnold
## 48 Becky Miles
## 49 Ben Easter
## 50 Benjamin Varney
## 51 Bernard Colby
## 52 Bernice Willis
## 53 Bertha Ferguson
## 54 Bessie Morrison
## 55 Beth Franklin
## 56 Betty White
## 57 Beverly Brooks
## 58 Bill Gavin
## 59 Billie Horton
## 60 Billy Poulin
## 61 Bob Pfeiffer
## 62 Bobbie Craig
## 63 Bobby Boudreau
## 64 Bonnie Hughes
## 65 Brad Mccurdy
## 66 Bradley Motley
## 67 Brandon Huey
## 68 Brandy Graves
## 69 Brenda Wright
## 70 Brent Harkins
## 71 Brett Cornwell
## 72 Brian Wyman
## 73 Brittany Riley
## 74 Bruce Schwarz
## 75 Bryan Hardison
## 76 Byron Box
## 77 Calvin Martel
## 78 Carl Artis
## 79 Carla Gutierrez
## 80 Carlos Coughlin
## 81 Carmen Owens
## 82 Carol Garcia
## 83 Carole Barnett
## 84 Caroline Bowman
## 85 Carolyn Perez
## 86 Carrie Porter
## 87 Casey Mena
## 88 Cassandra Walters
## 89 Catherine Campbell
## 90 Cathy Spencer
## 91 Cecil Vines
## 92 Chad Carbone
## 93 Charlene Alvarez
## 94 Charles Kowalski
## 95 Charlie Bess
## 96 Charlotte Hunter
## 97 Cheryl Murphy
## 98 Chester Benner
## 99 Chris Brothers
## 100 Christian Jung
## 101 Christina Ramirez
## 102 Christine Roberts
## 103 Christopher Greco
## 104 Christy Vargas
## 105 Cindy Fisher
## 106 Clara Shaw
## 107 Clarence Gamez
## 108 Claude Herzog
## 109 Claudia Fuller
## 110 Clayton Barbee
## 111 Clifford Bowens
## 112 Clifton Malcolm
## 113 Clinton Buford
## 114 Clyde Tobias
## 115 Cody Nolen
## 116 Colleen Burton
## 117 Connie Wallace
## 118 Constance Reid
## 119 Corey Hauser
## 120 Cory Meehan
## 121 Courtney Day
## 122 Craig Morrell
## 123 Crystal Ford
## 124 Curtis Irby
## 125 Cynthia Young
## 126 Daisy Bates
## 127 Dale Ratcliff
## 128 Dan Paine
## 129 Dana Hart
## 130 Daniel Cabral
## 131 Danielle Daniels
## 132 Danny Isom
## 133 Darlene Rose
## 134 Darrell Power
## 135 Darren Windham
## 136 Darryl Ashcraft
## 137 Daryl Larue
## 138 Dave Gardiner
## 139 David Royal
## 140 Dawn Sullivan
## 141 Dean Sauer
## 142 Deanna Byrd
## 143 Debbie Reyes
## 144 Deborah Walker
## 145 Debra Nelson
## 146 Delores Hansen
## 147 Denise Kelly
## 148 Dennis Gilman
## 149 Derek Blakely
## 150 Derrick Bourque
## 151 Diana Alexander
## 152 Diane Collins
## 153 Dianne Shelton
## 154 Dolores Wagner
## 155 Don Bone
## 156 Donald Mahon
## 157 Donna Thompson
## 158 Dora Medina
## 159 Doris Reed
## 160 Dorothy Taylor
## 161 Douglas Graf
## 162 Duane Tubbs
## 163 Dustin Gillette
## 164 Dwayne Olvera
## 165 Dwight Lombardi
## 166 Earl Shanks
## 167 Eddie Tomlin
## 168 Edgar Rhoads
## 169 Edith Mcdonald
## 170 Edna West
## 171 Eduardo Hiatt
## 172 Edward Baugh
## 173 Edwin Burk
## 174 Eileen Carr
## 175 Elaine Stevens
## 176 Eleanor Hunt
## 177 Elizabeth Brown
## 178 Ella Oliver
## 179 Ellen Simpson
## 180 Elmer Noe
## 181 Elsie Kelley
## 182 Emily Diaz
## 183 Emma Boyd
## 184 Enrique Forsythe
## 185 Eric Robert
## 186 Erica Matthews
## 187 Erik Guillen
## 188 Erika Pena
## 189 Erin Dunn
## 190 Ernest Stepp
## 191 Esther Crawford
## 192 Ethel Webb
## 193 Eugene Culpepper
## 194 Eva Ramos
## 195 Evelyn Morgan
## 196 Everett Banda
## 197 Felicia Sutton
## 198 Felix Gaffney
## 199 Fernando Churchill
## 200 Florence Woods
## 201 Floyd Gandy
## 202 Frances Parker
## 203 Francis Sikes
## 204 Francisco Skidmore
## 205 Frank Waggoner
## 206 Franklin Troutman
## 207 Fred Wheat
## 208 Freddie Duggan
## 209 Frederick Isbell
## 210 Gabriel Harder
## 211 Gail Knight
## 212 Gary Coy
## 213 Gene Sanborn
## 214 George Linton
## 215 Georgia Jacobs
## 216 Gerald Fultz
## 217 Geraldine Perkins
## 218 Gertrude Castillo
## 219 Gilbert Sledge
## 220 Gina Williamson
## 221 Gladys Hamilton
## 222 Glen Talbert
## 223 Glenda Frazier
## 224 Glenn Pullen
## 225 Gloria Cook
## 226 Gordon Allard
## 227 Grace Ellis
## 228 Greg Robins
## 229 Gregory Mauldin
## 230 Guy Brownlee
## 231 Gwendolyn May
## 232 Harold Martino
## 233 Harry Arce
## 234 Harvey Guajardo
## 235 Hazel Warren
## 236 Heather Morris
## 237 Hector Poindexter
## 238 Heidi Larson
## 239 Helen Harris
## 240 Henry Billingsley
## 241 Herbert Kruger
## 242 Herman Devore
## 243 Hilda Hopkins
## 244 Holly Fox
## 245 Howard Fortner
## 246 Hugh Waldrop
## 247 Ian Still
## 248 Ida Andrews
## 249 Irene Price
## 250 Irma Pearson
## 251 Isaac Oglesby
## 252 Ivan Cromwell
## 253 Jack Foust
## 254 Jackie Lynch
## 255 Jacob Lance
## 256 Jacqueline Long
## 257 Jaime Nettles
## 258 James Gannon
## 259 Jamie Waugh
## 260 Jamie Rice
## 261 Jane Bennett
## 262 Janet Phillips
## 263 Janice Ward
## 264 Jared Ely
## 265 Jason Morrissey
## 266 Javier Elrod
## 267 Jay Robb
## 268 Jean Bell
## 269 Jeanette Greene
## 270 Jeanne Lawson
## 271 Jeff East
## 272 Jeffery Pinson
## 273 Jeffrey Spear
## 274 Jennie Terry
## 275 Jennifer Davis
## 276 Jenny Castro
## 277 Jeremy Hurtado
## 278 Jerome Kenyon
## 279 Jerry Jordon
## 280 Jesse Schilling
## 281 Jessica Hall
## 282 Jessie Banks
## 283 Jessie Milam
## 284 Jesus Mccartney
## 285 Jill Hawkins
## 286 Jim Rea
## 287 Jimmie Eggleston
## 288 Jimmy Schrader
## 289 Jo Fowler
## 290 Joan Cooper
## 291 Joann Gardner
## 292 Joanne Robertson
## 293 Joe Gilliland
## 294 Joel Francisco
## 295 John Farnsworth
## 296 Johnnie Chisholm
## 297 Johnny Turpin
## 298 Jon Wiles
## 299 Jonathan Scarborough
## 300 Jordan Archuleta
## 301 Jorge Olivares
## 302 Jose Andrew
## 303 Joseph Joy
## 304 Josephine Gomez
## 305 Joshua Mark
## 306 Joy George
## 307 Joyce Edwards
## 308 Juan Fraley
## 309 Juanita Mason
## 310 Judith Cox
## 311 Judy Gray
## 312 Julia Flores
## 313 Julian Vest
## 314 Julie Sanchez
## 315 Julio Noland
## 316 June Carroll
## 317 Justin Ngo
## 318 Karen Jackson
## 319 Karl Seal
## 320 Katherine Rivera
## 321 Kathleen Adams
## 322 Kathryn Coleman
## 323 Kathy James
## 324 Katie Elliott
## 325 Kay Caldwell
## 326 Keith Rico
## 327 Kelly Torres
## 328 Kelly Knott
## 329 Ken Prewitt
## 330 Kenneth Gooden
## 331 Kent Arsenault
## 332 Kevin Schuler
## 333 Kim Cruz
## 334 Kimberly Lee
## 335 Kirk Stclair
## 336 Kristen Chavez
## 337 Kristin Johnston
## 338 Kristina Chambers
## 339 Kurt Emmons
## 340 Kyle Spurlock
## 341 Lance Pemberton
## 342 Larry Thrasher
## 343 Laura Rodriguez
## 344 Lauren Hudson
## 345 Laurie Lawrence
## 346 Lawrence Lawton
## 347 Leah Curtis
## 348 Lee Hawks
## 349 Lena Jensen
## 350 Leo Ebert
## 351 Leon Bostic
## 352 Leona Obrien
## 353 Leonard Schofield
## 354 Leroy Bustamante
## 355 Leslie Gordon
## 356 Leslie Seward
## 357 Lester Kraus
## 358 Lewis Lyman
## 359 Lillian Griffin
## 360 Lillie Kim
## 361 Linda Williams
## 362 Lisa Anderson
## 363 Lloyd Dowd
## 364 Lois Butler
## 365 Lonnie Tirado
## 366 Loretta Carpenter
## 367 Lori Wood
## 368 Lorraine Stephens
## 369 Louis Leone
## 370 Louise Jenkins
## 371 Lucille Holmes
## 372 Lucy Wheeler
## 373 Luis Yanez
## 374 Lydia Burke
## 375 Lynn Payne
## 376 Mabel Holland
## 377 Mae Fletcher
## 378 Manuel Murrell
## 379 Marc Outlaw
## 380 Marcia Dean
## 381 Marcus Hidalgo
## 382 Margaret Moore
## 383 Margie Wade
## 384 Maria Miller
## 385 Marian Mendoza
## 386 Marie Turner
## 387 Marilyn Ross
## 388 Mario Cheatham
## 389 Marion Snyder
## 390 Marion Ocampo
## 391 Marjorie Tucker
## 392 Mark Rinehart
## 393 Marlene Welch
## 394 Marsha Douglas
## 395 Marshall Thorn
## 396 Martha Gonzalez
## 397 Martin Bales
## 398 Marvin Yee
## 399 Mary Smith
## 400 Mathew Bolin
## 401 Matthew Mahan
## 402 Mattie Hoffman
## 403 Maureen Little
## 404 Maurice Crawley
## 405 Max Pitt
## 406 Maxine Silva
## 407 Megan Palmer
## 408 Melanie Armstrong
## 409 Melinda Fernandez
## 410 Melissa King
## 411 Melvin Ellington
## 412 Michael Silverman
## 413 Micheal Forman
## 414 Michele Grant
## 415 Michelle Clark
## 416 Miguel Betancourt
## 417 Mike Way
## 418 Mildred Bailey
## 419 Milton Howland
## 420 Minnie Romero
## 421 Miriam Mckinney
## 422 Misty Lambert
## 423 Mitchell Westmoreland
## 424 Monica Hicks
## 425 Morris Mccarter
## 426 Myrtle Fleming
## 427 Nancy Thomas
## 428 Naomi Jennings
## 429 Natalie Meyer
## 430 Nathan Runyon
## 431 Nathaniel Adam
## 432 Neil Renner
## 433 Nellie Garrett
## 434 Nelson Christenson
## 435 Nicholas Barfield
## 436 Nicole Peterson
## 437 Nina Soto
## 438 Nora Herrera
## 439 Norma Gonzales
## 440 Norman Currier
## 441 Olga Jimenez
## 442 Oscar Aquino
## 443 Pamela Baker
## 444 Patricia Johnson
## 445 Patrick Newsom
## 446 Patsy Davidson
## 447 Paul Trout
## 448 Paula Bryant
## 449 Pauline Henry
## 450 Pearl Garza
## 451 Pedro Chestnut
## 452 Peggy Myers
## 453 Penny Neal
## 454 Perry Swafford
## 455 Peter Menard
## 456 Philip Causey
## 457 Phillip Holm
## 458 Phyllis Foster
## 459 Priscilla Lowe
## 460 Rachel Barnes
## 461 Rafael Abney
## 462 Ralph Madrigal
## 463 Ramon Choate
## 464 Ramona Hale
## 465 Randall Neumann
## 466 Randy Gaither
## 467 Raul Fortier
## 468 Ray Houle
## 469 Raymond Mcwhorter
## 470 Rebecca Scott
## 471 Regina Berry
## 472 Reginald Kinder
## 473 Rene Mcalister
## 474 Renee Lane
## 475 Rhonda Kennedy
## 476 Ricardo Meador
## 477 Richard Mccrary
## 478 Rick Mattox
## 479 Ricky Shelby
## 480 Rita Graham
## 481 Robert Baughman
## 482 Roberta Harper
## 483 Roberto Vu
## 484 Robin Hayes
## 485 Rodney Moeller
## 486 Roger Quintanilla
## 487 Roland South
## 488 Ron Deluca
## 489 Ronald Weiner
## 490 Ronnie Ricketts
## 491 Rosa Reynolds
## 492 Rose Howard
## 493 Rosemary Schmidt
## 494 Ross Grey
## 495 Roy Whiting
## 496 Ruben Geary
## 497 Ruby Washington
## 498 Russell Brinson
## 499 Ruth Martinez
## 500 Ryan Salisbury
## 501 Sally Pierce
## 502 Salvador Teel
## 503 Sam Mcduffie
## 504 Samantha Duncan
## 505 Samuel Marlow
## 506 Sandra Martin
## 507 Sara Perry
## 508 Sarah Lewis
## 509 Scott Shelley
## 510 Sean Douglass
## 511 Sergio Stanfield
## 512 Seth Hannon
## 513 Shane Millard
## 514 Shannon Freeman
## 515 Sharon Robinson
## 516 Shawn Heaton
## 517 Sheila Wells
## 518 Shelly Watts
## 519 Sherri Rhodes
## 520 Sherry Marshall
## 521 Shirley Allen
## 522 Sidney Burleson
## 523 Sonia Gregory
## 524 Stacey Montgomery
## 525 Stacy Cunningham
## 526 Stanley Scroggins
## 527 Stella Moreno
## 528 Stephanie Mitchell
## 529 Stephen Qualls
## 530 Steve Mackenzie
## 531 Steven Curley
## 532 Sue Peters
## 533 Susan Wilson
## 534 Suzanne Nichols
## 535 Sylvia Ortiz
## 536 Tamara Nguyen
## 537 Tammy Sanders
## 538 Tanya Gilbert
## 539 Tara Ryan
## 540 Ted Breaux
## 541 Teresa Rogers
## 542 Terrance Roush
## 543 Terrence Gunderson
## 544 Terri Vasquez
## 545 Terry Carlson
## 546 Terry Grissom
## 547 Thelma Murray
## 548 Theodore Culp
## 549 Theresa Watson
## 550 Thomas Grigsby
## 551 Tiffany Jordan
## 552 Tim Cary
## 553 Timothy Bunn
## 554 Tina Simmons
## 555 Todd Tan
## 556 Tom Milner
## 557 Tommy Collazo
## 558 Toni Holt
## 559 Tony Carranza
## 560 Tonya Chapman
## 561 Tracey Barrett
## 562 Tracy Herrmann
## 563 Tracy Cole
## 564 Travis Estep
## 565 Troy Quigley
## 566 Tyler Wren
## 567 Tyrone Asher
## 568 Valerie Black
## 569 Vanessa Sims
## 570 Velma Lucas
## 571 Vera Mccoy
## 572 Vernon Chapa
## 573 Veronica Stone
## 574 Vicki Fields
## 575 Vickie Brewer
## 576 Victor Barkley
## 577 Victoria Gibson
## 578 Vincent Ralston
## 579 Viola Hanson
## 580 Violet Rodriquez
## 581 Virgil Wofford
## 582 Virginia Green
## 583 Vivian Ruiz
## 584 Wade Delvalle
## 585 Wallace Slone
## 586 Walter Perryman
## 587 Wanda Patterson
## 588 Warren Sherrod
## 589 Wayne Truong
## 590 Wendy Harrison
## 591 Wesley Bull
## 592 Willard Lumpkin
## 593 William Satterfield
## 594 Willie Markham
## 595 Willie Howell
## 596 Wilma Richards
## 597 Yolanda Weaver
## 598 Yvonne Watkins
## 599 Zachary HiteExample: Sort the customers by last name in descending order.
-- Sort by last_name in descending order from the customer table
SELECT first_name, last_name
FROM customer
ORDER BY last_name DESC;## first_name last_name
## 1 Cynthia Young
## 2 Marvin Yee
## 3 Luis Yanez
## 4 Brian Wyman
## 5 Brenda Wright
## 6 Tyler Wren
## 7 Florence Woods
## 8 Lori Wood
## 9 Virgil Wofford
## 10 Darren Windham
## 11 Susan Wilson
## 12 Bernice Willis
## 13 Gina Williamson
## 14 Linda Williams
## 15 Jon Wiles
## 16 Roy Whiting
## 17 Betty White
## 18 Lucy Wheeler
## 19 Fred Wheat
## 20 Mitchell Westmoreland
## 21 Edna West
## 22 Sheila Wells
## 23 Marlene Welch
## 24 Ronald Weiner
## 25 Ethel Webb
## 26 Yolanda Weaver
## 27 Mike Way
## 28 Jamie Waugh
## 29 Shelly Watts
## 30 Theresa Watson
## 31 Yvonne Watkins
## 32 Ruby Washington
## 33 Hazel Warren
## 34 Janice Ward
## 35 Cassandra Walters
## 36 Connie Wallace
## 37 Deborah Walker
## 38 Hugh Waldrop
## 39 Dolores Wagner
## 40 Frank Waggoner
## 41 Margie Wade
## 42 Roberto Vu
## 43 Cecil Vines
## 44 Julian Vest
## 45 Terri Vasquez
## 46 Benjamin Varney
## 47 Christy Vargas
## 48 Andy Vanhorn
## 49 Johnny Turpin
## 50 Marie Turner
## 51 Marjorie Tucker
## 52 Duane Tubbs
## 53 Wayne Truong
## 54 Franklin Troutman
## 55 Paul Trout
## 56 Kelly Torres
## 57 Eddie Tomlin
## 58 Clyde Tobias
## 59 Lonnie Tirado
## 60 Larry Thrasher
## 61 Marshall Thorn
## 62 Donna Thompson
## 63 Nancy Thomas
## 64 Jennie Terry
## 65 Salvador Teel
## 66 Dorothy Taylor
## 67 Todd Tan
## 68 Glen Talbert
## 69 Perry Swafford
## 70 Felicia Sutton
## 71 Dawn Sullivan
## 72 Veronica Stone
## 73 Ian Still
## 74 Alice Stewart
## 75 Elaine Stevens
## 76 Ernest Stepp
## 77 Lorraine Stephens
## 78 Kirk Stclair
## 79 Allison Stanley
## 80 Sergio Stanfield
## 81 Kyle Spurlock
## 82 Cathy Spencer
## 83 Jeffrey Spear
## 84 Roland South
## 85 Nina Soto
## 86 Marion Snyder
## 87 Mary Smith
## 88 Wallace Slone
## 89 Gilbert Sledge
## 90 Francisco Skidmore
## 91 Vanessa Sims
## 92 Ellen Simpson
## 93 Arthur Simpkins
## 94 Tina Simmons
## 95 Michael Silverman
## 96 Maxine Silva
## 97 Francis Sikes
## 98 Warren Sherrod
## 99 Dianne Shelton
## 100 Scott Shelley
## 101 Ricky Shelby
## 102 Clara Shaw
## 103 Earl Shanks
## 104 Leslie Seward
## 105 Aaron Selby
## 106 Karl Seal
## 107 Stanley Scroggins
## 108 Rebecca Scott
## 109 Bruce Schwarz
## 110 Anthony Schwab
## 111 Kevin Schuler
## 112 Jimmy Schrader
## 113 Leonard Schofield
## 114 Rosemary Schmidt
## 115 Jesse Schilling
## 116 Jonathan Scarborough
## 117 Dean Sauer
## 118 William Satterfield
## 119 Tammy Sanders
## 120 Julie Sanchez
## 121 Gene Sanborn
## 122 Ryan Salisbury
## 123 Tara Ryan
## 124 Annie Russell
## 125 Nathan Runyon
## 126 Vivian Ruiz
## 127 David Royal
## 128 Terrance Roush
## 129 Marilyn Ross
## 130 Darlene Rose
## 131 Minnie Romero
## 132 Teresa Rogers
## 133 Violet Rodriquez
## 134 Laura Rodriguez
## 135 Sharon Robinson
## 136 Greg Robins
## 137 Joanne Robertson
## 138 Christine Roberts
## 139 Eric Robert
## 140 Jay Robb
## 141 Katherine Rivera
## 142 Mark Rinehart
## 143 Brittany Riley
## 144 Keith Rico
## 145 Ronnie Ricketts
## 146 Ashley Richardson
## 147 Wilma Richards
## 148 Jamie Rice
## 149 Sherri Rhodes
## 150 Edgar Rhoads
## 151 Rosa Reynolds
## 152 Debbie Reyes
## 153 Neil Renner
## 154 Constance Reid
## 155 Doris Reed
## 156 Jim Rea
## 157 Audrey Ray
## 158 Dale Ratcliff
## 159 Andre Rapp
## 160 Eva Ramos
## 161 Christina Ramirez
## 162 Vincent Ralston
## 163 Roger Quintanilla
## 164 Troy Quigley
## 165 Stephen Qualls
## 166 Andrew Purdy
## 167 Glenn Pullen
## 168 Irene Price
## 169 Ken Prewitt
## 170 Darrell Power
## 171 Anne Powell
## 172 Billy Poulin
## 173 Carrie Porter
## 174 Hector Poindexter
## 175 Max Pitt
## 176 Jeffery Pinson
## 177 Sally Pierce
## 178 Janet Phillips
## 179 Bob Pfeiffer
## 180 Nicole Peterson
## 181 Sue Peters
## 182 Walter Perryman
## 183 Sara Perry
## 184 Geraldine Perkins
## 185 Carolyn Perez
## 186 Erika Pena
## 187 Lance Pemberton
## 188 Irma Pearson
## 189 Lynn Payne
## 190 Wanda Patterson
## 191 Frances Parker
## 192 Megan Palmer
## 193 Dan Paine
## 194 Carmen Owens
## 195 Marc Outlaw
## 196 Sylvia Ortiz
## 197 Dwayne Olvera
## 198 Annette Olson
## 199 Ella Oliver
## 200 Jorge Olivares
## 201 Isaac Oglesby
## 202 Marion Ocampo
## 203 Leona Obrien
## 204 Cody Nolen
## 205 Julio Noland
## 206 Elmer Noe
## 207 Suzanne Nichols
## 208 Tamara Nguyen
## 209 Justin Ngo
## 210 Patrick Newsom
## 211 Randall Neumann
## 212 Jaime Nettles
## 213 Debra Nelson
## 214 Penny Neal
## 215 Peggy Myers
## 216 Manuel Murrell
## 217 Thelma Murray
## 218 Cheryl Murphy
## 219 Bradley Motley
## 220 Jason Morrissey
## 221 Bessie Morrison
## 222 Heather Morris
## 223 Craig Morrell
## 224 Evelyn Morgan
## 225 Stella Moreno
## 226 Anita Morales
## 227 Margaret Moore
## 228 Stacey Montgomery
## 229 Rodney Moeller
## 230 Stephanie Mitchell
## 231 Tom Milner
## 232 Alicia Mills
## 233 Maria Miller
## 234 Shane Millard
## 235 Becky Miles
## 236 Jessie Milam
## 237 Natalie Meyer
## 238 Marian Mendoza
## 239 Peter Menard
## 240 Casey Mena
## 241 Antonio Meek
## 242 Cory Meehan
## 243 Dora Medina
## 244 Ricardo Meador
## 245 Raymond Mcwhorter
## 246 Miriam Mckinney
## 247 Sam Mcduffie
## 248 Edith Mcdonald
## 249 Brad Mccurdy
## 250 Richard Mccrary
## 251 Vera Mccoy
## 252 Jesus Mccartney
## 253 Morris Mccarter
## 254 Rene Mcalister
## 255 Alfredo Mcadams
## 256 Gwendolyn May
## 257 Gregory Mauldin
## 258 Rick Mattox
## 259 Erica Matthews
## 260 Juanita Mason
## 261 Harold Martino
## 262 Ruth Martinez
## 263 Sandra Martin
## 264 Calvin Martel
## 265 Sherry Marshall
## 266 Samuel Marlow
## 267 Willie Markham
## 268 Joshua Mark
## 269 Clifton Malcolm
## 270 Donald Mahon
## 271 Matthew Mahan
## 272 Ralph Madrigal
## 273 Steve Mackenzie
## 274 Jackie Lynch
## 275 Lewis Lyman
## 276 Willard Lumpkin
## 277 Velma Lucas
## 278 Priscilla Lowe
## 279 Barry Lovelace
## 280 Amy Lopez
## 281 Jacqueline Long
## 282 Dwight Lombardi
## 283 Maureen Little
## 284 George Linton
## 285 Sarah Lewis
## 286 Louis Leone
## 287 Kimberly Lee
## 288 Lawrence Lawton
## 289 Jeanne Lawson
## 290 Laurie Lawrence
## 291 Daryl Larue
## 292 Heidi Larson
## 293 Renee Lane
## 294 Jacob Lance
## 295 Misty Lambert
## 296 Herbert Kruger
## 297 Lester Kraus
## 298 Charles Kowalski
## 299 Kelly Knott
## 300 Gail Knight
## 301 Melissa King
## 302 Reginald Kinder
## 303 Lillie Kim
## 304 Jerome Kenyon
## 305 Rhonda Kennedy
## 306 Denise Kelly
## 307 Elsie Kelley
## 308 Alan Kahn
## 309 Christian Jung
## 310 Joseph Joy
## 311 Jerry Jordon
## 312 Tiffany Jordan
## 313 Barbara Jones
## 314 Kristin Johnston
## 315 Patricia Johnson
## 316 Olga Jimenez
## 317 Lena Jensen
## 318 Naomi Jennings
## 319 Louise Jenkins
## 320 Kathy James
## 321 Georgia Jacobs
## 322 Karen Jackson
## 323 Danny Isom
## 324 Frederick Isbell
## 325 Curtis Irby
## 326 Jeremy Hurtado
## 327 Charlotte Hunter
## 328 Eleanor Hunt
## 329 Bonnie Hughes
## 330 Brandon Huey
## 331 Lauren Hudson
## 332 Milton Howland
## 333 Willie Howell
## 334 Rose Howard
## 335 Ray Houle
## 336 Billie Horton
## 337 Hilda Hopkins
## 338 Toni Holt
## 339 Lucille Holmes
## 340 Phillip Holm
## 341 Mabel Holland
## 342 Mattie Hoffman
## 343 Zachary Hite
## 344 Anna Hill
## 345 Marcus Hidalgo
## 346 Monica Hicks
## 347 Eduardo Hiatt
## 348 Claude Herzog
## 349 Tracy Herrmann
## 350 Nora Herrera
## 351 Angela Hernandez
## 352 Pauline Henry
## 353 Alberto Henning
## 354 Andrea Henderson
## 355 Shawn Heaton
## 356 Robin Hayes
## 357 Lee Hawks
## 358 Jill Hawkins
## 359 Arnold Havens
## 360 Corey Hauser
## 361 Arlene Harvey
## 362 Dana Hart
## 363 Wendy Harrison
## 364 Helen Harris
## 365 Roberta Harper
## 366 Brent Harkins
## 367 Bryan Hardison
## 368 Gabriel Harder
## 369 Viola Hanson
## 370 Delores Hansen
## 371 Seth Hannon
## 372 Gladys Hamilton
## 373 Jessica Hall
## 374 Ramona Hale
## 375 Carla Gutierrez
## 376 Terrence Gunderson
## 377 Erik Guillen
## 378 Harvey Guajardo
## 379 Armando Gruber
## 380 Terry Grissom
## 381 Thomas Grigsby
## 382 Lillian Griffin
## 383 Ross Grey
## 384 Alex Gresham
## 385 Sonia Gregory
## 386 Jeanette Greene
## 387 Virginia Green
## 388 Christopher Greco
## 389 Judy Gray
## 390 Brandy Graves
## 391 Michele Grant
## 392 Rita Graham
## 393 Douglas Graf
## 394 Leslie Gordon
## 395 Kenneth Gooden
## 396 Adam Gooch
## 397 Martha Gonzalez
## 398 Norma Gonzales
## 399 Josephine Gomez
## 400 Dennis Gilman
## 401 Joe Gilliland
## 402 Dustin Gillette
## 403 Tanya Gilbert
## 404 Victoria Gibson
## 405 Joy George
## 406 Ruben Geary
## 407 Bill Gavin
## 408 Pearl Garza
## 409 Nellie Garrett
## 410 Joann Gardner
## 411 Dave Gardiner
## 412 Carol Garcia
## 413 James Gannon
## 414 Floyd Gandy
## 415 Clarence Gamez
## 416 Randy Gaither
## 417 Felix Gaffney
## 418 Gerald Fultz
## 419 Claudia Fuller
## 420 Shannon Freeman
## 421 Glenda Frazier
## 422 Beth Franklin
## 423 Joel Francisco
## 424 Juan Fraley
## 425 Holly Fox
## 426 Jo Fowler
## 427 Jack Foust
## 428 Phyllis Foster
## 429 Howard Fortner
## 430 Raul Fortier
## 431 Enrique Forsythe
## 432 Micheal Forman
## 433 Crystal Ford
## 434 Julia Flores
## 435 Mae Fletcher
## 436 Myrtle Fleming
## 437 Cindy Fisher
## 438 Vicki Fields
## 439 Melinda Fernandez
## 440 Bertha Ferguson
## 441 Alexander Fennell
## 442 John Farnsworth
## 443 Ann Evans
## 444 Travis Estep
## 445 Kurt Emmons
## 446 Jared Ely
## 447 Javier Elrod
## 448 Grace Ellis
## 449 Katie Elliott
## 450 Melvin Ellington
## 451 Jimmie Eggleston
## 452 Joyce Edwards
## 453 Leo Ebert
## 454 Ben Easter
## 455 Jeff East
## 456 Erin Dunn
## 457 Samantha Duncan
## 458 Freddie Duggan
## 459 Lloyd Dowd
## 460 Sean Douglass
## 461 Marsha Douglas
## 462 Amber Dixon
## 463 Emily Diaz
## 464 Herman Devore
## 465 Wade Delvalle
## 466 Ron Deluca
## 467 Alvin Deloach
## 468 Marcia Dean
## 469 Courtney Day
## 470 Jennifer Davis
## 471 Patsy Davidson
## 472 Danielle Daniels
## 473 Leah Curtis
## 474 Norman Currier
## 475 Steven Curley
## 476 Stacy Cunningham
## 477 Eugene Culpepper
## 478 Theodore Culp
## 479 Kim Cruz
## 480 Albert Crouse
## 481 Ivan Cromwell
## 482 Maurice Crawley
## 483 Esther Crawford
## 484 Bobbie Craig
## 485 Gary Coy
## 486 Judith Cox
## 487 Carlos Coughlin
## 488 Brett Cornwell
## 489 Allan Cornish
## 490 Joan Cooper
## 491 Gloria Cook
## 492 Diane Collins
## 493 Tommy Collazo
## 494 Kathryn Coleman
## 495 Tracy Cole
## 496 Bernard Colby
## 497 Adrian Clary
## 498 Michelle Clark
## 499 Austin Cintron
## 500 Fernando Churchill
## 501 Nelson Christenson
## 502 Ramon Choate
## 503 Johnnie Chisholm
## 504 Pedro Chestnut
## 505 Mario Cheatham
## 506 Kristen Chavez
## 507 Tonya Chapman
## 508 Vernon Chapa
## 509 Kristina Chambers
## 510 Philip Causey
## 511 Jenny Castro
## 512 Gertrude Castillo
## 513 Alfred Casillas
## 514 Tim Cary
## 515 Amanda Carter
## 516 June Carroll
## 517 Tony Carranza
## 518 Eileen Carr
## 519 Loretta Carpenter
## 520 Terry Carlson
## 521 Chad Carbone
## 522 Catherine Campbell
## 523 Kay Caldwell
## 524 Daniel Cabral
## 525 Deanna Byrd
## 526 Allen Butterfield
## 527 Lois Butler
## 528 Leroy Bustamante
## 529 Colleen Burton
## 530 April Burns
## 531 Sidney Burleson
## 532 Lydia Burke
## 533 Edwin Burk
## 534 Timothy Bunn
## 535 Wesley Bull
## 536 Clinton Buford
## 537 Paula Bryant
## 538 Guy Brownlee
## 539 Elizabeth Brown
## 540 Chris Brothers
## 541 Beverly Brooks
## 542 Russell Brinson
## 543 Vickie Brewer
## 544 Ted Breaux
## 545 Ana Bradley
## 546 Emma Boyd
## 547 Byron Box
## 548 Caroline Bowman
## 549 Clifford Bowens
## 550 Derrick Bourque
## 551 Bobby Boudreau
## 552 Leon Bostic
## 553 Don Bone
## 554 Mathew Bolin
## 555 Derek Blakely
## 556 Valerie Black
## 557 Agnes Bishop
## 558 Henry Billingsley
## 559 Miguel Betancourt
## 560 Charlie Bess
## 561 Regina Berry
## 562 Jane Bennett
## 563 Chester Benner
## 564 Jean Bell
## 565 Robert Baughman
## 566 Edward Baugh
## 567 Daisy Bates
## 568 Tracey Barrett
## 569 Carole Barnett
## 570 Rachel Barnes
## 571 Victor Barkley
## 572 Nicholas Barfield
## 573 Angel Barclay
## 574 Clayton Barbee
## 575 Jessie Banks
## 576 Everett Banda
## 577 Martin Bales
## 578 Pamela Baker
## 579 Mildred Bailey
## 580 Alma Austin
## 581 Tyrone Asher
## 582 Darryl Ashcraft
## 583 Carl Artis
## 584 Kent Arsenault
## 585 Beatrice Arnold
## 586 Melanie Armstrong
## 587 Jordan Archuleta
## 588 Harry Arce
## 589 Oscar Aquino
## 590 Ida Andrews
## 591 Jose Andrew
## 592 Lisa Anderson
## 593 Charlene Alvarez
## 594 Shirley Allen
## 595 Gordon Allard
## 596 Diana Alexander
## 597 Kathleen Adams
## 598 Nathaniel Adam
## 599 Rafael AbneyExample: Sort the customers by first name in the ascending order first and then sort the sorted result set by the last name in descending order
-- Sort by first_name in the ascending order, and then sort by last name in descending order from the customer table
SELECT first_name, last_name
FROM customer
ORDER BY first_name ASC,
last_name DESC;## first_name last_name
## 1 Aaron Selby
## 2 Adam Gooch
## 3 Adrian Clary
## 4 Agnes Bishop
## 5 Alan Kahn
## 6 Albert Crouse
## 7 Alberto Henning
## 8 Alex Gresham
## 9 Alexander Fennell
## 10 Alfred Casillas
## 11 Alfredo Mcadams
## 12 Alice Stewart
## 13 Alicia Mills
## 14 Allan Cornish
## 15 Allen Butterfield
## 16 Allison Stanley
## 17 Alma Austin
## 18 Alvin Deloach
## 19 Amanda Carter
## 20 Amber Dixon
## 21 Amy Lopez
## 22 Ana Bradley
## 23 Andre Rapp
## 24 Andrea Henderson
## 25 Andrew Purdy
## 26 Andy Vanhorn
## 27 Angel Barclay
## 28 Angela Hernandez
## 29 Anita Morales
## 30 Ann Evans
## 31 Anna Hill
## 32 Anne Powell
## 33 Annette Olson
## 34 Annie Russell
## 35 Anthony Schwab
## 36 Antonio Meek
## 37 April Burns
## 38 Arlene Harvey
## 39 Armando Gruber
## 40 Arnold Havens
## 41 Arthur Simpkins
## 42 Ashley Richardson
## 43 Audrey Ray
## 44 Austin Cintron
## 45 Barbara Jones
## 46 Barry Lovelace
## 47 Beatrice Arnold
## 48 Becky Miles
## 49 Ben Easter
## 50 Benjamin Varney
## 51 Bernard Colby
## 52 Bernice Willis
## 53 Bertha Ferguson
## 54 Bessie Morrison
## 55 Beth Franklin
## 56 Betty White
## 57 Beverly Brooks
## 58 Bill Gavin
## 59 Billie Horton
## 60 Billy Poulin
## 61 Bob Pfeiffer
## 62 Bobbie Craig
## 63 Bobby Boudreau
## 64 Bonnie Hughes
## 65 Brad Mccurdy
## 66 Bradley Motley
## 67 Brandon Huey
## 68 Brandy Graves
## 69 Brenda Wright
## 70 Brent Harkins
## 71 Brett Cornwell
## 72 Brian Wyman
## 73 Brittany Riley
## 74 Bruce Schwarz
## 75 Bryan Hardison
## 76 Byron Box
## 77 Calvin Martel
## 78 Carl Artis
## 79 Carla Gutierrez
## 80 Carlos Coughlin
## 81 Carmen Owens
## 82 Carol Garcia
## 83 Carole Barnett
## 84 Caroline Bowman
## 85 Carolyn Perez
## 86 Carrie Porter
## 87 Casey Mena
## 88 Cassandra Walters
## 89 Catherine Campbell
## 90 Cathy Spencer
## 91 Cecil Vines
## 92 Chad Carbone
## 93 Charlene Alvarez
## 94 Charles Kowalski
## 95 Charlie Bess
## 96 Charlotte Hunter
## 97 Cheryl Murphy
## 98 Chester Benner
## 99 Chris Brothers
## 100 Christian Jung
## 101 Christina Ramirez
## 102 Christine Roberts
## 103 Christopher Greco
## 104 Christy Vargas
## 105 Cindy Fisher
## 106 Clara Shaw
## 107 Clarence Gamez
## 108 Claude Herzog
## 109 Claudia Fuller
## 110 Clayton Barbee
## 111 Clifford Bowens
## 112 Clifton Malcolm
## 113 Clinton Buford
## 114 Clyde Tobias
## 115 Cody Nolen
## 116 Colleen Burton
## 117 Connie Wallace
## 118 Constance Reid
## 119 Corey Hauser
## 120 Cory Meehan
## 121 Courtney Day
## 122 Craig Morrell
## 123 Crystal Ford
## 124 Curtis Irby
## 125 Cynthia Young
## 126 Daisy Bates
## 127 Dale Ratcliff
## 128 Dan Paine
## 129 Dana Hart
## 130 Daniel Cabral
## 131 Danielle Daniels
## 132 Danny Isom
## 133 Darlene Rose
## 134 Darrell Power
## 135 Darren Windham
## 136 Darryl Ashcraft
## 137 Daryl Larue
## 138 Dave Gardiner
## 139 David Royal
## 140 Dawn Sullivan
## 141 Dean Sauer
## 142 Deanna Byrd
## 143 Debbie Reyes
## 144 Deborah Walker
## 145 Debra Nelson
## 146 Delores Hansen
## 147 Denise Kelly
## 148 Dennis Gilman
## 149 Derek Blakely
## 150 Derrick Bourque
## 151 Diana Alexander
## 152 Diane Collins
## 153 Dianne Shelton
## 154 Dolores Wagner
## 155 Don Bone
## 156 Donald Mahon
## 157 Donna Thompson
## 158 Dora Medina
## 159 Doris Reed
## 160 Dorothy Taylor
## 161 Douglas Graf
## 162 Duane Tubbs
## 163 Dustin Gillette
## 164 Dwayne Olvera
## 165 Dwight Lombardi
## 166 Earl Shanks
## 167 Eddie Tomlin
## 168 Edgar Rhoads
## 169 Edith Mcdonald
## 170 Edna West
## 171 Eduardo Hiatt
## 172 Edward Baugh
## 173 Edwin Burk
## 174 Eileen Carr
## 175 Elaine Stevens
## 176 Eleanor Hunt
## 177 Elizabeth Brown
## 178 Ella Oliver
## 179 Ellen Simpson
## 180 Elmer Noe
## 181 Elsie Kelley
## 182 Emily Diaz
## 183 Emma Boyd
## 184 Enrique Forsythe
## 185 Eric Robert
## 186 Erica Matthews
## 187 Erik Guillen
## 188 Erika Pena
## 189 Erin Dunn
## 190 Ernest Stepp
## 191 Esther Crawford
## 192 Ethel Webb
## 193 Eugene Culpepper
## 194 Eva Ramos
## 195 Evelyn Morgan
## 196 Everett Banda
## 197 Felicia Sutton
## 198 Felix Gaffney
## 199 Fernando Churchill
## 200 Florence Woods
## 201 Floyd Gandy
## 202 Frances Parker
## 203 Francis Sikes
## 204 Francisco Skidmore
## 205 Frank Waggoner
## 206 Franklin Troutman
## 207 Fred Wheat
## 208 Freddie Duggan
## 209 Frederick Isbell
## 210 Gabriel Harder
## 211 Gail Knight
## 212 Gary Coy
## 213 Gene Sanborn
## 214 George Linton
## 215 Georgia Jacobs
## 216 Gerald Fultz
## 217 Geraldine Perkins
## 218 Gertrude Castillo
## 219 Gilbert Sledge
## 220 Gina Williamson
## 221 Gladys Hamilton
## 222 Glen Talbert
## 223 Glenda Frazier
## 224 Glenn Pullen
## 225 Gloria Cook
## 226 Gordon Allard
## 227 Grace Ellis
## 228 Greg Robins
## 229 Gregory Mauldin
## 230 Guy Brownlee
## 231 Gwendolyn May
## 232 Harold Martino
## 233 Harry Arce
## 234 Harvey Guajardo
## 235 Hazel Warren
## 236 Heather Morris
## 237 Hector Poindexter
## 238 Heidi Larson
## 239 Helen Harris
## 240 Henry Billingsley
## 241 Herbert Kruger
## 242 Herman Devore
## 243 Hilda Hopkins
## 244 Holly Fox
## 245 Howard Fortner
## 246 Hugh Waldrop
## 247 Ian Still
## 248 Ida Andrews
## 249 Irene Price
## 250 Irma Pearson
## 251 Isaac Oglesby
## 252 Ivan Cromwell
## 253 Jack Foust
## 254 Jackie Lynch
## 255 Jacob Lance
## 256 Jacqueline Long
## 257 Jaime Nettles
## 258 James Gannon
## 259 Jamie Waugh
## 260 Jamie Rice
## 261 Jane Bennett
## 262 Janet Phillips
## 263 Janice Ward
## 264 Jared Ely
## 265 Jason Morrissey
## 266 Javier Elrod
## 267 Jay Robb
## 268 Jean Bell
## 269 Jeanette Greene
## 270 Jeanne Lawson
## 271 Jeff East
## 272 Jeffery Pinson
## 273 Jeffrey Spear
## 274 Jennie Terry
## 275 Jennifer Davis
## 276 Jenny Castro
## 277 Jeremy Hurtado
## 278 Jerome Kenyon
## 279 Jerry Jordon
## 280 Jesse Schilling
## 281 Jessica Hall
## 282 Jessie Milam
## 283 Jessie Banks
## 284 Jesus Mccartney
## 285 Jill Hawkins
## 286 Jim Rea
## 287 Jimmie Eggleston
## 288 Jimmy Schrader
## 289 Jo Fowler
## 290 Joan Cooper
## 291 Joann Gardner
## 292 Joanne Robertson
## 293 Joe Gilliland
## 294 Joel Francisco
## 295 John Farnsworth
## 296 Johnnie Chisholm
## 297 Johnny Turpin
## 298 Jon Wiles
## 299 Jonathan Scarborough
## 300 Jordan Archuleta
## 301 Jorge Olivares
## 302 Jose Andrew
## 303 Joseph Joy
## 304 Josephine Gomez
## 305 Joshua Mark
## 306 Joy George
## 307 Joyce Edwards
## 308 Juan Fraley
## 309 Juanita Mason
## 310 Judith Cox
## 311 Judy Gray
## 312 Julia Flores
## 313 Julian Vest
## 314 Julie Sanchez
## 315 Julio Noland
## 316 June Carroll
## 317 Justin Ngo
## 318 Karen Jackson
## 319 Karl Seal
## 320 Katherine Rivera
## 321 Kathleen Adams
## 322 Kathryn Coleman
## 323 Kathy James
## 324 Katie Elliott
## 325 Kay Caldwell
## 326 Keith Rico
## 327 Kelly Torres
## 328 Kelly Knott
## 329 Ken Prewitt
## 330 Kenneth Gooden
## 331 Kent Arsenault
## 332 Kevin Schuler
## 333 Kim Cruz
## 334 Kimberly Lee
## 335 Kirk Stclair
## 336 Kristen Chavez
## 337 Kristin Johnston
## 338 Kristina Chambers
## 339 Kurt Emmons
## 340 Kyle Spurlock
## 341 Lance Pemberton
## 342 Larry Thrasher
## 343 Laura Rodriguez
## 344 Lauren Hudson
## 345 Laurie Lawrence
## 346 Lawrence Lawton
## 347 Leah Curtis
## 348 Lee Hawks
## 349 Lena Jensen
## 350 Leo Ebert
## 351 Leon Bostic
## 352 Leona Obrien
## 353 Leonard Schofield
## 354 Leroy Bustamante
## 355 Leslie Seward
## 356 Leslie Gordon
## 357 Lester Kraus
## 358 Lewis Lyman
## 359 Lillian Griffin
## 360 Lillie Kim
## 361 Linda Williams
## 362 Lisa Anderson
## 363 Lloyd Dowd
## 364 Lois Butler
## 365 Lonnie Tirado
## 366 Loretta Carpenter
## 367 Lori Wood
## 368 Lorraine Stephens
## 369 Louis Leone
## 370 Louise Jenkins
## 371 Lucille Holmes
## 372 Lucy Wheeler
## 373 Luis Yanez
## 374 Lydia Burke
## 375 Lynn Payne
## 376 Mabel Holland
## 377 Mae Fletcher
## 378 Manuel Murrell
## 379 Marc Outlaw
## 380 Marcia Dean
## 381 Marcus Hidalgo
## 382 Margaret Moore
## 383 Margie Wade
## 384 Maria Miller
## 385 Marian Mendoza
## 386 Marie Turner
## 387 Marilyn Ross
## 388 Mario Cheatham
## 389 Marion Snyder
## 390 Marion Ocampo
## 391 Marjorie Tucker
## 392 Mark Rinehart
## 393 Marlene Welch
## 394 Marsha Douglas
## 395 Marshall Thorn
## 396 Martha Gonzalez
## 397 Martin Bales
## 398 Marvin Yee
## 399 Mary Smith
## 400 Mathew Bolin
## 401 Matthew Mahan
## 402 Mattie Hoffman
## 403 Maureen Little
## 404 Maurice Crawley
## 405 Max Pitt
## 406 Maxine Silva
## 407 Megan Palmer
## 408 Melanie Armstrong
## 409 Melinda Fernandez
## 410 Melissa King
## 411 Melvin Ellington
## 412 Michael Silverman
## 413 Micheal Forman
## 414 Michele Grant
## 415 Michelle Clark
## 416 Miguel Betancourt
## 417 Mike Way
## 418 Mildred Bailey
## 419 Milton Howland
## 420 Minnie Romero
## 421 Miriam Mckinney
## 422 Misty Lambert
## 423 Mitchell Westmoreland
## 424 Monica Hicks
## 425 Morris Mccarter
## 426 Myrtle Fleming
## 427 Nancy Thomas
## 428 Naomi Jennings
## 429 Natalie Meyer
## 430 Nathan Runyon
## 431 Nathaniel Adam
## 432 Neil Renner
## 433 Nellie Garrett
## 434 Nelson Christenson
## 435 Nicholas Barfield
## 436 Nicole Peterson
## 437 Nina Soto
## 438 Nora Herrera
## 439 Norma Gonzales
## 440 Norman Currier
## 441 Olga Jimenez
## 442 Oscar Aquino
## 443 Pamela Baker
## 444 Patricia Johnson
## 445 Patrick Newsom
## 446 Patsy Davidson
## 447 Paul Trout
## 448 Paula Bryant
## 449 Pauline Henry
## 450 Pearl Garza
## 451 Pedro Chestnut
## 452 Peggy Myers
## 453 Penny Neal
## 454 Perry Swafford
## 455 Peter Menard
## 456 Philip Causey
## 457 Phillip Holm
## 458 Phyllis Foster
## 459 Priscilla Lowe
## 460 Rachel Barnes
## 461 Rafael Abney
## 462 Ralph Madrigal
## 463 Ramon Choate
## 464 Ramona Hale
## 465 Randall Neumann
## 466 Randy Gaither
## 467 Raul Fortier
## 468 Ray Houle
## 469 Raymond Mcwhorter
## 470 Rebecca Scott
## 471 Regina Berry
## 472 Reginald Kinder
## 473 Rene Mcalister
## 474 Renee Lane
## 475 Rhonda Kennedy
## 476 Ricardo Meador
## 477 Richard Mccrary
## 478 Rick Mattox
## 479 Ricky Shelby
## 480 Rita Graham
## 481 Robert Baughman
## 482 Roberta Harper
## 483 Roberto Vu
## 484 Robin Hayes
## 485 Rodney Moeller
## 486 Roger Quintanilla
## 487 Roland South
## 488 Ron Deluca
## 489 Ronald Weiner
## 490 Ronnie Ricketts
## 491 Rosa Reynolds
## 492 Rose Howard
## 493 Rosemary Schmidt
## 494 Ross Grey
## 495 Roy Whiting
## 496 Ruben Geary
## 497 Ruby Washington
## 498 Russell Brinson
## 499 Ruth Martinez
## 500 Ryan Salisbury
## 501 Sally Pierce
## 502 Salvador Teel
## 503 Sam Mcduffie
## 504 Samantha Duncan
## 505 Samuel Marlow
## 506 Sandra Martin
## 507 Sara Perry
## 508 Sarah Lewis
## 509 Scott Shelley
## 510 Sean Douglass
## 511 Sergio Stanfield
## 512 Seth Hannon
## 513 Shane Millard
## 514 Shannon Freeman
## 515 Sharon Robinson
## 516 Shawn Heaton
## 517 Sheila Wells
## 518 Shelly Watts
## 519 Sherri Rhodes
## 520 Sherry Marshall
## 521 Shirley Allen
## 522 Sidney Burleson
## 523 Sonia Gregory
## 524 Stacey Montgomery
## 525 Stacy Cunningham
## 526 Stanley Scroggins
## 527 Stella Moreno
## 528 Stephanie Mitchell
## 529 Stephen Qualls
## 530 Steve Mackenzie
## 531 Steven Curley
## 532 Sue Peters
## 533 Susan Wilson
## 534 Suzanne Nichols
## 535 Sylvia Ortiz
## 536 Tamara Nguyen
## 537 Tammy Sanders
## 538 Tanya Gilbert
## 539 Tara Ryan
## 540 Ted Breaux
## 541 Teresa Rogers
## 542 Terrance Roush
## 543 Terrence Gunderson
## 544 Terri Vasquez
## 545 Terry Grissom
## 546 Terry Carlson
## 547 Thelma Murray
## 548 Theodore Culp
## 549 Theresa Watson
## 550 Thomas Grigsby
## 551 Tiffany Jordan
## 552 Tim Cary
## 553 Timothy Bunn
## 554 Tina Simmons
## 555 Todd Tan
## 556 Tom Milner
## 557 Tommy Collazo
## 558 Toni Holt
## 559 Tony Carranza
## 560 Tonya Chapman
## 561 Tracey Barrett
## 562 Tracy Herrmann
## 563 Tracy Cole
## 564 Travis Estep
## 565 Troy Quigley
## 566 Tyler Wren
## 567 Tyrone Asher
## 568 Valerie Black
## 569 Vanessa Sims
## 570 Velma Lucas
## 571 Vera Mccoy
## 572 Vernon Chapa
## 573 Veronica Stone
## 574 Vicki Fields
## 575 Vickie Brewer
## 576 Victor Barkley
## 577 Victoria Gibson
## 578 Vincent Ralston
## 579 Viola Hanson
## 580 Violet Rodriquez
## 581 Virgil Wofford
## 582 Virginia Green
## 583 Vivian Ruiz
## 584 Wade Delvalle
## 585 Wallace Slone
## 586 Walter Perryman
## 587 Wanda Patterson
## 588 Warren Sherrod
## 589 Wayne Truong
## 590 Wendy Harrison
## 591 Wesley Bull
## 592 Willard Lumpkin
## 593 William Satterfield
## 594 Willie Markham
## 595 Willie Howell
## 596 Wilma Richards
## 597 Yolanda Weaver
## 598 Yvonne Watkins
## 599 Zachary HiteProblem: Get the customer_ID numbers for the top 10 highest payment amounts.
-- Select customer ID numbers and sort them based on the top 10 highest payment amounts
SELECT customer_ID, amount
FROM payment
ORDER BY amount DESC
LIMIT 10;## customer_id amount
## 1 591 11.99
## 2 195 11.99
## 3 116 11.99
## 4 237 11.99
## 5 592 11.99
## 6 13 11.99
## 7 362 11.99
## 8 204 11.99
## 9 571 10.99
## 10 558 10.99Problem: Get the titles of the movies with film ids 1-5.
-- Select the titles of the movies with film ids 1-5
SELECT title, film_id
FROM film
ORDER BY film_id ASC
LIMIT 5;## title film_id
## 1 Academy Dinosaur 1
## 2 Ace Goldfinger 2
## 3 Adaptation Holes 3
## 4 Affair Prejudice 4
## 5 African Egg 5