BetterHelp Challenge

Step 1: Database

You regulary publish a top cat or top dog contest in the local newspaper. The photos used for the contest have been generously submitted by patrons and now you want to send them a cat or dog postcard as a token of thanks. You want to make sure to give the cat or dog enthusiast an appropriate cat or dog postcard respectivley.

Given the tables below, write a SQL query that returns:

• Name
• Date of most recent submission (if any)
• Favorite Animal guess as: C, D, or U, where:
  • C = Likely Cat (more cat picture submissions than other submissions)
  • D = Likely Dog (more dog picture submissions than other submissions)
  • U = Undtermined (no photo submissions on record, or C and D are tied for first place.
• Address

Tables:

• People
  • ID
  • Name
  • Address
• Submissions
  • ID
  • People_ID
  • Submission_Date
  • Animal (1 = Cat, -1 = Dog)

Enter your SQL query below:

Step 2: Javascript

For some reason, this form is submitted via AJAX, but there are a couple of bugs preventing that from working. Use your browser's console to fix it.

Results: