92

Restaurant Performance Index

HardJOINarithmeticcomplex formula

Problem Description

Write a SQL query to calculate a performance index: (avg_rating * review_count) / avg_cost_for_two * 100.

Expected Columns

  • restaurant_name
  • performance_index

Example Output

| restaurant_name | performance_index | |-----------------|-------------------| | Hyderabadi House | 100.0 | | Tandoori Nights | 75.0 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#92 Restaurant Performance Index
Hard

Loading schema...

Loading editor...

No results yet

Run a query to see results