rob@XE:11g2> select given_name, ranking, gender from top_usa_names
2 order by 1 ASC;
GIVEN_NAME RANKING GENDER
==================== ========== ======
AARON 31 M
ABBY 33 F
ADAM 38 M
ADRIAN 84 M
ALEC 94 M
ALEX 3 M
ALEXA 55 F
ALEXANDRA 94 F
ALEXIS 16 F
ALLIE 87 F
ALLISON 56 F
ALYSSA 19 F
AMANDA 10 F
AMBER 25 F
AMY 61 F
ANDREA 58 F
ANDREW 11 M
ANDY 75 M
ANNA 18 F
ANNIE 99 F
ANTHONY 21 M
ASHLEY 3 F
AUSTIN 13 M
AUTUMN 78 F
BAILEY 91 F
BEN 28 M
BILLY 96 M
BLAKE 85 M
BRANDON 10 M
BRETT 82 M
BRIAN 37 M
BRIANNA 27 F
BRITTANY 15 F
BROOKE 52 F
CAITLIN 66 F
CALEB 53 M
CAMERON 52 M
CARLOS 95 M
CAROLYN 97 F
CHASE 73 M
CHELSEA 59 F
CHEYENNE 100 F
CHLOE 74 F
CHRIS 4 M
CHRISTIAN 51 M
CHRISTINA 54 F
CHRISTOPHER 44 M
CLAIRE 89 F
CODY 23 M
COLE 76 M
CONNOR 49 M
COURTNEY 21 F
DAKOTA 81 M
DANIEL 12 M
DANIELLE 30 F
DAVID 8 M
DESTINY 77 F
DEVIN 66 M
DUSTIN 83 M
DYLAN 26 M
ELIZABETH 20 F
EMILY 1 F
EMMA 23 F
ERIC 32 M
ERICA 96 F
ERIN 31 F
ETHAN 36 M
EVAN 71 M
GABBY 95 F
GARRETT 77 M
GRACE 40 F
HAILEY 68 F
HALEY 29 F
HANNAH 4 F
HEATHER 57 F
HUNTER 61 M
IAN 65 M
ISAAC 79 M
ISAIAH 70 M
JACK 40 M
JACOB 6 M
JAKE 15 M
JAMES 16 M
JAMIE 71 F
JARED 69 M
JASMINE 36 F
JASON 67 M
JENNA 70 F
JENNIFER 43 F
JEREMY 50 M
JESSE 62 M
JESSICA 5 F
JOE 48 M
JOEY 60 M
JOHN 7 M
JONATHAN 33 M
JORDAN 22 M
JORDAN 50 F
JORGE 91 M
JOSE 63 M
JOSEPH 43 M
JOSH 18 M
JOSHUA 25 M
JULIA 47 F
JUSTIN 14 M
KAITLYN 46 F
KATE 62 F
KATELYN 90 F
KATHERINE 93 F
KATIE 7 F
KAYLA 9 F
KAYLEE 98 F
KELLY 35 F
KELSEY 41 F
KEVIN 24 M
KRISTEN 88 F
KYLE 20 M
LAURA 44 F
LAUREN 13 F
LEXI 73 F
LIAM 98 M
LINDSEY 83 F
LOGAN 27 M
LUKE 59 M
MACKENZIE 80 F
MADDIE 67 F
MADISON 26 F
MAGGIE 84 F
MARCUS 78 M
MARIA 53 F
MARIAH 82 F
MARISSA 65 F
MARK 57 M
MARY 63 F
MASON 86 M
MATT 17 M
MATTHEW 19 M
MAX 58 M
MEGAN 12 F
MEGHAN 86 F
MELISSA 49 F
MICHAEL 1 M
MICHELLE 39 F
MIKE 56 M
MIRANDA 72 F
MOLLY 69 F
MORGAN 24 F
NATALIE 37 F
NATE 74 M
NATHAN 29 M
NICHOLAS 54 F
NICK 9 M
NICOLE 14 F
NIKKI 60 F
NOAH 55 M
OLIVIA 17 F
PAIGE 48 F
PATRICK 42 M
PAUL 90 M
PETER 89 M
RACHEL 11 F
REBECCA 38 F
RICKY 99 M
ROBERT 35 M
RYAN 5 M
SABRINA 75 F
SAM 85 F
SAM 30 M
SAMANTHA 8 F
SAMUEL 87 M
SARA 34 F
SARAH 2 F
SAVANNAH 51 F
SEAN 41 M
SETH 88 M
SHANE 92 M
SHANNON 81 F
SHELBY 42 F
SIERRA 45 F
STEPHANIE 22 F
STEVEN 68 M
SYDNEY 32 F
TAYLOR 6 F
TAYLOR 93 M
THOMAS 46 M
TIFFANY 64 F
TOM 97 M
TONY 72 M
TORI 76 F
TRAVIS 100 M
TREVOR 64 M
TYLER 2 M
VANESSA 92 F
VICTORIA 28 F
WILL 39 M
WILLIAM 45 M
ZACH 34 M
ZACHARY 47 M
ZACK 80 M
ZOE 79 F
200 rows selected.