I have a table in MySQL database. which is having 3 records shown below. The table : columns name address phone comments 1st record raj Chennai 232329 null 2nd record raj Chennai 232329 null 3rd record raj Chennai 232329 null…
I am trying to find the YoY growth of the users and trying to write a mysql query using window functions. Below is my query to find the lag : select substr(create_time, 1, 4) as date, count(*) as count, lag(count(*),…
I have a query that gets quantity 1, value 1 , total 1 what I am trying to get is the following result quantity 1, value 1, total 1, sum quantity, sum total / sum quantity as value summ, sum…
Consider the following tables: create table `t1` ( `date` date, `value` int ); create table `t2` ( `date` date, `value` int ); insert into `t1` (`date`, `value`) values ("2022-01-01", 1), ("2022-03-01", 3), ("2022-04-01", 4); insert into `t2` (`date`, `value`) values…
Consider the following tables: create table `t1` ( `date` date, `value` int ); create table `t2` ( `date` date, `value` int ); create table `t3` ( `date` date, `value` int ); insert into `t1` (`date`, `value`) values ("2022-01-01", 1), ("2022-03-01",…
I'm facing a "Duplicate entry" error when trying to insert data into a MySQL table, even though the values being inserted are unique and should not violate any constraints. I have a unique constraint defined on a column, but the…
Table "ORDER": ID ORDERN_NUM 1 123 2 321 3 456 Table "RECEIVERS": FIRST_NAME ID LAST_NAME Pete 1 Tyler Sarah 1 Bowden Bart 2 Simpson Table "PRODUCTS": TYPE ID Towel 1 Pen 1 Spoon 2 We can say "FIRST_NAME" and "TYPE"…
Context : Rails 6 app hosted in Docker, using docker-compose When the Rails container starts, I get : Mysql2::Error::ConnectionError: Access denied for user 'user'@'%' to database 'db_production' Even after MySQL is fully initalized My docker-compose.yml : services: app_production: image: app_production…
I have two tables products sale_items -------- ---------- id id code product_id name quantity price ... ... count the number of sales per product, all in one query. I tried something like this, but it doesn't work: public function getProductsListing()…
Wrote a query for this small dataset to find the total score of students. Conditions: Display student total score (top scorer on the top). If student gave an exam 2 time than pick the max score. if student have max…