🔗
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
|
|---|---|---|---|---|
| Organic Honey | 8.30 | 3 | 83.00 | 10 |
| Generic Item | 9.89 | 2 | 4846.10 | 490 |
| Generic Item | 7.18 | 1 | 3575.64 | 498 |
| Generic Item | 6.45 | 2 | 2908.95 | 451 |
| Generic Item | 6.66 | 3 | 2650.68 | 398 |
| Premium Coffee Beans | 7.56 | 2 | 5382.72 | 712 |
| Basic Product | 6.08 | 2 | 1854.40 | 305 |
| iPhone 14 | 1497.76 | 1 | 934602.24 | 624 |
| Basic Product | 5.33 | 3 | 746.20 | 140 |
| Basic Product | 9.12 | 1 | 3903.36 | 428 |