I have 3 tables: customers (CustomerID) orders (OrderID, CustomerID) orders_products (OrderID, ProductID) I need to select each customer with their total orders and total number of products ordered by them. To count total orders by each customer, the query is:…
I'm trying to get the totals of a table grouped by names that are similar. Here is my test mysql: CREATE TABLE IF NOT EXISTS aa ( clicks INT NOT NULL, locn varchar (30) NOT NULL ) CHARACTER SET utf8…
I have an table and I want to fill the null value with previous value order by date but there have an group too For example: Table X: Date Group value 1/1/2023 A null 2/1/2023 A Kevin 3/1/2023 A null…
I have a table source_flight_destination like this ID Flight source destination 1 Indigo II BB 2 Air Asia AA II 3 Indigo BB JJ 4 spice jet SS BB 5 Indigo JJ SS 6 Air Asia II KK 7 spice…
I have a postgresql table contains a list of email addresses. The table has three columns, Email, EmailServer (e.g., gmail.com, outlook.com, msn.com, and yahoo.com.ca etc.), and Valid (boolean). Now, I want to group those emails by EmailServer and then update…
I have the following structre id val 1 ... . . 2 ... . . 3 null 3 null 3 null 4 ... . . Basically each id has multiple no. of values. And an id has either all values…
I have a quick question in relation to windowing in MySQL SELECT Client, User, Date, Flag, lag(Date) over (partition by Client,User order by Date asc) as last_date, lag(Flag) over (partition by Client,User order by Date asc) as last_flag, case when…
I created SQL query which should count the number of e-mails sent after 20.12.2022 for each user_id from ACTIONQUEUE table. My query counts everything correctly for all users, but it doesn't returns 0 in the table for the users with…
I have two models, Business and Employee: from django.db import models class Business(models.Model): name = models.CharField(max_length=150) # ... class Employee(models.Model): business = models.ForeignKey( Business, related_name="employees", on_delete=models.CASCADE, ) name = models.CharField(max_length=150) # ... Here's a sample data: Business.objects.create(name="first company") Business.objects.create(name="second company")…
I have to get total price in month from a date yy-mm-dd with jpql query but I can't do it. @Query(value = "select new com.talan.food.dto.MonthIncomes( function('date_format',date,'%Y-%m'),SUM(p.price)) from Reservation p group by function('date_format',p.date,'%Y-%m')" ) public List<MonthIncomes> getIncomeByMonth(); And in the table…