Display the first name and last name for everyone that lives in Payson.?

Write a query 

Update:

SQL 

Attachment image

2 Answers

Relevance
  • 4 weeks ago
    Favorite Answer

    You did not tell us what programming language you are using so I can not five you the code.  The best I can do is give you the steps.

    1) Open the data file.  (I am going to assume that the data is separated by commas in the data file.)

    2) Read in the first line of data

    3) Store everything up to the first comma in a variable called "first_name"

    4) Store everything up to the next comma in a variable called "last_name"

    5) Continue to store all the data from the first line into variable

    6) See if the value in the variable "city" is Payson

    7) If it is, display/print the first_name and last_name

    8) Read next line of the data file

    9) Continue until you reach the end of the data file

  • 4 weeks ago

    select * from homework by do your own

Still have questions? Get your answers by asking now.