Question: In this assignment you will create a regular expression to retrieve a subset data from the purpose column of the taxdata table in the readonly

 In this assignment you will create a regular expression to retrieve

In this assignment you will create a regular expression to retrieve a subset data from the purpose column of the taxdata table in the readonly database (access details below). Write a regular expressions to retrieve that meet the following criteria: Lines that end with a question mark (?) (don't forget to escape) As an example (not the solution to this assignment), if you were looking for lines where the very first character was an upper case character letter you would run the following query: SELECT purpose FROM taxdata WHERE purpose ' ' [AZ] ' ORDER BY purpose DESC LIMIT 3; The autograder will add all the SQL - all you need is to enter the appropriate regular expression below. Enter a regular expression like [AZ] Here are the first few lines: 1. The Mille Lacs Smallmouth Alliance is a charitable non-profit organization dedicated to rebuilding, preserving and maintaining Mille Lacs Lake as a world class trophy smallmouth bass fishery. Our work will include: educating fishermen, local businesses and visitors to the lake about the benefits of catch and release and advocating with conservation officials about sound fish management practices. We believe a healthy smallmouth bass fishery contributes to the economic vitality of the Mille Lacs Lake area through tourism and overall property values and a robust community. The Alliance works with the Minnesota Department of Natural Resources to educate and preserve the smallmouth bass populations in Minnesota and specifically the Lake Mille Lacs fishery.? 2. Teaching stem PROGRAM SERVICE ACCOMPLISHMENTS???? Here are access details for a readonly database: Host: pg.pg4e.com Port: 5432 Database: readonly User: readonly Password: (hide/show copy) psql -h pg.pg4e.com -p 5432 -U readonly readonly Here is the schema for the taxdata table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!