🔗
Advanced Joins
Database relationships and computed fields demonstration
Database relationships demo:
View category associations, supplier counts, and computed fields like total value - all with optimized queries
|
Product Name
|
Price
|
Suppliers
|
Total Value
|
Stock
|
|---|---|---|---|---|
| Generic Item | 1.14 | 2 | 687.42 | 603 |
| Premium Coffee Beans | 8.90 | 1 | 1326.10 | 149 |
| Basic Product | 2.29 | 1 | 329.76 | 144 |
| Dark Chocolate | 3.57 | 2 | 2181.27 | 611 |
| Generic Item | 3.22 | 1 | 2257.22 | 701 |
| Basic Product | 5.38 | 3 | 2259.60 | 420 |
| Think and Grow Rich | 8.47 | 3 | 4556.86 | 538 |
| The Silent Patient | 7.70 | 3 | 1347.50 | 175 |
| Organic Honey | 3.88 | 3 | 830.32 | 214 |
| Dried Fruits | 4.31 | 1 | 2736.85 | 635 |