# Add excellent reviews from the product database to the dealer's offerings from nested import product_db, dealer_db from pythonql.helpers import print_table res = [ select (d.dealer, d.make, d.model, d.year, d.purchase_price, d.ad_price, reviews) for d in dealer_db, p in product_db let p_make = try p['manufacturer']['company'] except p['manufacturer'] where d.model == p['model'] and d.make == p_make let reviews = [ select r for r in p['reviews'] where try r['stars'] == 5 except False ] ] print_table(res)
