I have a table with the following schema: `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `bookingDate` date NOT NULL, PRIMARY KEY(`id`) I need to get all dates of the current month where there's less than 5 bookings. (meaning where less than…
I'm running the code bellow via cron jobs in order to disable out-of-stock products from been displayed on my web site. Could anyone who knows the prestashop's database structure helps me to add an exception for 2 product categories with…
I would like to go through all the IDs and classify each ID as Car only, Bike only, both, and ignore anything with truck. In the end I would like to see only one ID with specific Product_category. Structure of…
Trying to insert right row but can't because it violates check constraint Table: CREATE TABLE IF NOT EXISTS public.authors ( au_id character varying(11) COLLATE pg_catalog."default" NOT NULL, au_lname character varying(40) COLLATE pg_catalog."default" NOT NULL, au_fname character varying(20) COLLATE pg_catalog."default" NOT…
I have 2 tables: Table tms_bills id load_id company_name 1 11 company1 2 11 company1 3 11 company2 4 12 company3 Table tms_payments id amount payment_associate_id 11 100 2 12 200 2 13 200 3 14 50 6 I want…
The execution order in SQL is the following: FROM --> WHERE --> GROUP BY --> HAVING --> SELECT --> ORDER BY --> LIMIT In my query I am using a CASE WHEN statement and an aggregate function in the SELECT…
I have a set of sql statements, CREATE TABLE PRICING( CodeVillage INT, TypeCabin INT, CodeSeason CHAR(2), WeekPrice INT, PRIMARY KEY(CodeVillage, TypeCabin, CodeSeason) ); CREATE TABLE SEASON( CodeSeason CHAR(2) PRIMARY KEY, NameSeason VARCHAR(20), CONSTRAINT Fk_Pricing_CodeSeason Foreign KEY (CodeSeason) REFERENCES PRICING(CodeSeason) );…
I have a table CREATE TABLE consumer_occurrence_restoration_times ( consumer_id INT, start_time TIMESTAMP, end_time TIMESTAMP ); where the data is INSERT INTO consumer_occurrence_restoration_times (consumer_id, start_time, end_time) VALUES (1, '2023-09-24 20:00:00', '2023-09-25 12:00:00'), (2, '2023-09-24 21:00:00', '2023-09-25 13:00:00'), (1, '2023-09-26 20:00:00', '2023-09-28…
I am trying to get a column which specify the points by comparing the value from original table to min and max value from another table. I have a main table, which consists of few columns of values and the…
I am trying to improve the performance of a query. I was thinking of using AsNoTracking(), but I am not sure if the location where it is put will make a difference i.e.(before Select() or after, before Include() or after,…