| | 25 | ==Примери == |
| | 26 | <!DOCTYPE html> |
| | 27 | <html> |
| | 28 | <head> |
| | 29 | <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.5/dist/css/bootstrap.min.css" rel="stylesheet" |
| | 30 | integrity="sha384-SgOJa3DmI69IUzQ2PVdRZhwQ+dy64/BUtbMJw1MZ8t5HZApcHrRKUc4W0kG879m7" crossorigin="anonymous"> |
| | 31 | <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.5/dist/js/bootstrap.bundle.min.js" |
| | 32 | integrity="sha384-k6d4wzSIapyDyv1kpU366/PK5hCdSbCRGRCMv+eplOQJWyd1fbcAu9OCUj5zNLiq" |
| | 33 | crossorigin="anonymous"></script> |
| | 34 | <title>Track Count Per Genre</title> |
| | 35 | </head> |
| | 36 | <body class="d-flex bg-light"> |
| | 37 | {% include 'sidebar.html' %} |
| | 38 | <div class="container mt-5"> |
| | 39 | <h1 class="text-center mb-4">Track Count Per Genre</h1> |
| | 40 | |
| | 41 | <div class="list-group"> |
| | 42 | {% for row in data %} |
| | 43 | <a href="#" class="list-group-item list-group-item-action"> |
| | 44 | {{ row.genre }} - {{ row.count }} tracks |
| | 45 | </a> |
| | 46 | {% empty %} |
| | 47 | <div class="alert alert-warning" role="alert"> |
| | 48 | No data available. |
| | 49 | </div> |
| | 50 | {% endfor %} |
| | 51 | </div> |
| | 52 | </div> |
| | 53 | </body> |
| | 54 | </html> |
| | 55 | |
| | 56 | == 1. Album List == |
| | 57 | [[Image(ER.2.png, width=800, align=center)]] |
| | 58 | == 2. Artist List == |
| | 59 | [[Image(ER.2.png, width=800, align=center)]] |
| | 60 | == 3. Track List == |
| | 61 | [[Image(ER.2.png, width=800, align=center)]] |
| | 62 | == 4. Average Track Duration == |
| | 63 | [[Image(ER.2.png, width=800, align=center)]] |
| | 64 | == 5. Average Track Price per Artist == |
| | 65 | [[Image(ER.2.png, width=800, align=center)]] |
| | 66 | == 6. Artist with Highest Earnings == |
| | 67 | [[Image(ER.2.png, width=800, align=center)]] |
| | 68 | == 7. Track Count per Genre == |
| | 69 | [[Image(ER.2.png, width=800, align=center)]] |
| | 70 | == 8. Create Customer == |
| | 71 | [[Image(ER.2.png, width=800, align=center)]] |
| | 72 | == 9. Rank List of Most Active Customers == |
| | 73 | [[Image(ER.2.png, width=800, align=center)]] |
| | 74 | == 10. Media TypePercentage == |
| | 75 | [[Image(ER.2.png, width=800, align=center)]] |
| | 76 | == 11. Most Popular Genre per Customer == |
| | 77 | [[Image(ER.2.png, width=800, align=center)]] |
| | 78 | == 12. Genres perCustomer == |
| | 79 | [[Image(ER.2.png, width=800, align=center)]] |
| | 80 | == 13. Invoices per Customer == |
| | 81 | [[Image(ER.2.png, width=800, align=center)]] |
| | 82 | == 14. Most Popular Artists Per Customer == |
| | 83 | [[Image(ER.2.png, width=800, align=center)]] |
| | 84 | == 15. Update Manager == |
| | 85 | [[Image(ER.2.png, width=800, align=center)]] |
| | 86 | == 16. Create Playlist == |
| | 87 | [[Image(ER.2.png, width=800, align=center)]] |
| | 88 | == 17. Add Tracks to Playlist == |
| | 89 | [[Image(ER.2.png, width=800, align=center)]] |
| | 90 | == 18. Create Invoice == |
| | 91 | [[Image(ER.2.png, width=800, align=center)]] |
| | 92 | == 19. Add Invoice Lines == |
| | 93 | [[Image(ER.2.png, width=800, align=center)]] |
| | 94 | == 20. Delete Records == |
| | 95 | [[Image(ER.2.png, width=800, align=center)]] |
