Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started