|
Last change
on this file was 59b2e9c, checked in by ManuelTrajcev <manueltrajcev7@…>, 2 weeks ago |
|
querry mostr popular artist per customer for each genre
|
-
Property mode
set to
100644
|
|
File size:
1.8 KB
|
| Rev | Line | |
|---|
| [bfca48b] | 1 | <!DOCTYPE html>
|
|---|
| [4abe330] | 2 | <html lang="en">
|
|---|
| [bfca48b] | 3 | <head>
|
|---|
| [4abe330] | 4 | <meta charset="UTF-8">
|
|---|
| 5 | <meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|---|
| [bfca48b] | 6 | <title>Average Track Price per Artist</title>
|
|---|
| [4abe330] | 7 | <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.5/dist/css/bootstrap.min.css" rel="stylesheet"
|
|---|
| 8 | integrity="sha384-SgOJa3DmI69IUzQ2PVdRZhwQ+dy64/BUtbMJw1MZ8t5HZApcHrRKUc4W0kG879m7" crossorigin="anonymous">
|
|---|
| 9 | <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.5/dist/js/bootstrap.bundle.min.js"
|
|---|
| 10 | integrity="sha384-k6d4wzSIapyDyv1kpU366/PK5hCdSbCRGRCMv+eplOQJWyd1fbcAu9OCUj5zNLiq"
|
|---|
| 11 | crossorigin="anonymous"></script>
|
|---|
| [bfca48b] | 12 | </head>
|
|---|
| [4abe330] | 13 | <body class="d-flex bg-light">
|
|---|
| 14 |
|
|---|
| 15 | {% include 'sidebar.html' %}
|
|---|
| 16 |
|
|---|
| 17 | <div class="container mt-5">
|
|---|
| 18 | <h1 class="mb-4 text-center">Average Track Price per Artist</h1>
|
|---|
| 19 |
|
|---|
| 20 | <h4 class="mb-4 text-center">Name - Average Track Price</h4>
|
|---|
| 21 |
|
|---|
| 22 | {% if not data %}
|
|---|
| 23 | <div class="alert alert-warning" role="alert">
|
|---|
| 24 | No data available.
|
|---|
| 25 | </div>
|
|---|
| 26 | {% else %}
|
|---|
| 27 | <ul class="list-group">
|
|---|
| 28 | {% for row in data %}
|
|---|
| 29 | <li class="list-group-item d-flex justify-content-between align-items-center">
|
|---|
| 30 | <div class="col-6">
|
|---|
| [59b2e9c] | 31 | {{ row.name }}
|
|---|
| [4abe330] | 32 | </div>
|
|---|
| 33 | <div class="col-6 text-end">
|
|---|
| 34 | {% if row.avg_price_per_track == 'not enogu data' %}
|
|---|
| 35 | <span class="badge bg-danger rounded-pill">No data available</span>
|
|---|
| 36 | {% else %}
|
|---|
| 37 | <span class="badge bg-success rounded-pill">${{ row.avg_price_per_track|floatformat:2 }}</span>
|
|---|
| 38 | {% endif %}
|
|---|
| 39 | </div>
|
|---|
| 40 | </li>
|
|---|
| 41 | {% endfor %}
|
|---|
| 42 | </ul>
|
|---|
| 43 | {% endif %}
|
|---|
| 44 | </div>
|
|---|
| [bfca48b] | 45 |
|
|---|
| 46 | </body>
|
|---|
| 47 | </html>
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
