I have a table with an item, its cost and the date it was added. CREATE TABLE item_prices ( item_id INT, item_name VARCHAR(30), item_price DECIMAL(12, 2), created_dttm DATETIME ); INSERT INTO item_prices(item_id, item_name, item_price, created_dttm) VALUES (1, 'spoon', 10.20 ,…
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")…