Expires in:
The Price is Right
Your dataset contains three tables from a pizza restaurant:
A transactions table with order date, product, and quantity
A products table with the current price for each product
A price history table with the price changes for each product over time
Your task is to look up the price for each product in the transactions table at that point in time, accurately reflecting the price changes.
NOTE: If the effective date of a price change is equal to the order date for a transaction, then that is the price that should be reflected.
See example below:
Submit your solution
What is the total revenue from the transactions? (round down to nearest integer)
Styled, Responsive and Ready to RollNo need to spend time changing colors and styles manually. Our component & layouts are styled out of the box Not just a UI KitPowered up with Framer's animation library and custom code componentsDark, Light and Dynamic componentsComponents will automatically adjust theme and color pallette based on your brand Responsive color stylesComponents and Layouts can easily be customized to your brand color in a few clicks 1st Feb24 layouts3rd March12 components2nd April44 componentsA Lifetime of UpdatesContinuously evolving library adjusting to the latest design trends and Framer Updates Responsive Text StylesText styles adapt to different breakpoints, avoiding the need to manually adjust MonthlyYearlyStyled ComponentsComponents & layouts are automatically styled based on your CopyCopy to ClipboardCopy, Paste, RepeatCopy and paste 100+ styled, responsive, interactive elements in two click TemplatesGet 4 custom templates worth $200+ with Pro. View Templates DesktopTabletPhoneResponsiveComponents will automatically adjust to the screen size that they are pasted into
Check back soon for the full solution video & tutorial from Maven instructors
