Ex. SELECT * FROM A JOIN B ON A.idx = B.idx JOIN C ON A.idx = C.idx WHERE A.create_dt BETWEEN '2023-05-01' AND '2023-05-31' OR A.last_dt BETWEEN '2023-05-01' AND '2023-05-31' OR B.create_dt BETWEEN '2023-05-01' AND '2023-05-31' OR B.last_dt BETWEEN '2023-05-01' AND…
Get a column with total sale by each agent and second column with total sale for company as well in each row I have 3 tables, queries added below for table schemas and data. I want to get total sales…
I am using Cubecart for a customer website, and frustratingly they have used comma separated values to associate certain option IDs to products. I now need to create a custom table which gets all this information out into a useful…
We have a table called "subscriptions" that stores information about salon subscriptions. The table has the following columns: subscriptions id, start_date, end_date, subscription_plan_id, salon_id We want to write a query that provides the following information for each month: Date Total…
I have 2 tables, which represent one to many relationship CREATE TABLE a( id int, a_text varchar(255) ); And CREATE TABLE b( a_id int, b_text varchar(255) ); Where column b_text contains enum values. Table A: Id a_text 1 'text 1'…
I have two tables, both tables have a column with the same value. Table 1 |sn|Name |Age |Address |Date | |1 |Name 1|Age 1|Address 1|18-05-2023| |2 |Name 2|Age 2|Address 2|21-05-2023| |3 |Name 3|Age 3|Address 3|21-05-2023| |4 |Name 4|Age 4|Address 4|21-05-2023|…
my_tickets +-----------+---------+ | ticket_id | user_id | +-----------+---------+ | 186 | 2 | | 187 | 2 | | 188 | 2 | | 253 | 33 | | 254 | 33 | | 256 | 33 | | 261…
I'm getting an error while attempting to populate my table with the following query: INSERT INTO d_table SELECT category.name, film_category.film_id FROM category INNER JOIN film_category.film_id ON film_category.category_id = category.category_id It returns an error "relation film_category.film_id does not exist" These are…
As it is right now ->join() is a query builder so it wouldn't using Model that has SoftDelete, there is too many codes that used join in my project so I don't want to manually replace it all with eager…
I'm currently trying to find a way to return all rows in which there is at least one other row with the same values in any number of columns and unique values in any number of other columns. I want…