Today, we're working with regular expressions. Check out the Tutorial tab for learning materials and an instructional video!
Consider a database table, Emails, which has the attributes First Name and Email ID. Given rows of data simulating the Emails table, print an alphabetically-ordered list of people whose email address ends in .
The first line contains an integer, , total number of rows in the table.
Each of the subsequent lines contains space-separated strings denoting a person's first name and email ID, respectively.
Each of the first names consists of lower case letters only.
Each of the email IDs consists of lower case letters , and only.
The length of the first name is no longer than 20.
The length of the email ID is no longer than 50.
Print an alphabetically-ordered list of first names for every user with a gmail account. Each name must be printed on a new line.