Missing Table or Field?


#1

https://www.codecademy.com/en/courses/sql-table-transformation/lessons/date-number-string-functions/exercises/dates-iii


Here is the problem to solve:

Each of the baked goods is packaged by Baker's Market exactly five hours, twenty minutes, and two days after the delivery (designated by delivery_time). Create a query returning all the packaging times for the goods in the baked_goods table

I cannot find any thing like a name for a shop called "Baker's Market" anywhere... I understand what it is asking.... just don't see any data that will allow me to pass the test...

Thoughts?

Be sure to alias the package time column as package_time.


select 	delivery_time,
	datetime(
    delivery_time,
   '5 hours',
   '20 minutes',
   '2 days'
  ) as package_time
from baked_goods
;


#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.