# Order the dealer’s offers by the difference in ad_price and # average selling price. from nested import product_db, dealer_db from pythonql.helpers import print_table res = [ select (d.dealer, d.make, d.model, d.year, d.ad_price, diff) for d in dealer_db, p in product_db let p_make = try p['manufacturer']['company'] except p['manufacturer'] where p['model'] == d.model and p_make == d.make let pr = p['price'], p_price = try pr['average_price'] except pr, diff = d.ad_price - p_price order by diff desc ] print_table(res)
Welcome to the PythonQL Web Demo
The Demo is organized into a number of scenarios that demonstrate the power and usability of PythonQL.
Each scenario illustrates a specific use case in data science that is addressed by PythonQL.