🔗
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.07 | 2 | 467.59 | 437 |
| Denim Jeans | 16.26 | 1 | 1560.96 | 96 |
| Generic Item | 3.23 | 3 | 1573.01 | 487 |
| Generic Item | 6.31 | 2 | 1924.55 | 305 |
| Generic Item | 1.54 | 1 | 1492.26 | 969 |
| Dell XPS | 1272.00 | 1 | 660168.00 | 519 |
| Basic Product | 7.12 | 3 | 5496.64 | 772 |
| Generic Item | 1.82 | 1 | 997.36 | 548 |
| Generic Item | 8.55 | 3 | 5326.65 | 623 |
| Generic Item | 7.35 | 1 | 7151.55 | 973 |