#128 · SQL and analytics · 6.9 minJSON in SQL: Query Semi-Structured Data in SQLite
In SQLite, a total stored as the text 9.50 passed a filter for totals over 20; a cast fixed it.
Python 3.12.152 videos tagged "sqlite json".
#128 · SQL and analytics · 6.9 minIn SQLite, a total stored as the text 9.50 passed a filter for totals over 20; a cast fixed it.
Python 3.12.15
#267 · Data modelling · 6.9 minThree orders' shipping adds up to 9 pounds; after flattening the JSON into item rows it summed to 17.
Python 3.12.15