I am trying to produce a data from a football table. The table can be seen below and the data that is needed is highlighted. The data that needs to be produced
I'm trying to improve my query for this topic at hand. I'm trying to find the top 5 and bottom 5 growth rates per state from 2020 to 2021 in my org. The table h
I have been exploring dbt tools and I came across the following code snippet : coalesce(customer_orders.number_of_orders, 0) as number_of_orders I understand th
I got a list of IDs as comma seperated list of JSON values and some example data sets are like below [340596,340597,340595] This list can be huge sometimes 50k
I m looking for advices in report generating per client, per product, per salesman, in a given period, using mysql and php. I m currently working on an applicat
I have the following query to get appointments that need remind once a month if they are not done yet. I want to get records with 30, 60, 90, 120,etc... in the
This must be a niche scenario since I have not been able to find a similar question around and in my brief testing in my SQL workbench just using the string in
I have python script which uses subprocess.run() getting dump file by curl and input dump file by mysql cmd = "curl {0}/{1} -o /tmp/{2}".format(dir_name,file_na
in Mysql I am trying to get end date excluding weekends like my function GET_DATE_WEEKDAYS('2022-03-24',5) giving - 2022-03-17 which is fine it is giving issue
I created a table with a query: CREATE TABLE Department ( EmpID INT NOT NULL, Designation VARCHAR(80) NOT NULL, Department VARCHAR(80) NOT NULL, PRIMARY KEY(Emp
I am attempting to connect a FastAPI with sqlAlchemy to a mysql db container. I am using the alias. Unfortunately it wont connect and I don't know why. Using My
When running this site locally, no problem. I have my server/client in different folders and the server is set to update the database on Heroku. I have one simp
first i have two problem here the first problem when i run this query it gives me this Error //ERROR SQLSTATE[42S22]: Column not found: 1054 Unknown column '390
Trying to link two tables that are in one database please help with syntax
I'm asking the question cuz all the related posts i found are not answered Error at line 21 Screenshot Hello guys I need some help with this Query, at line 21 I
I'm having a big problem that a few rows of the table are not returning by the native query of hibernate (Spring Data), although if I put the same query in the
I have a products database structure as follows: Categories > Sub categories > Child categories > Products the respective table names in mySql database
$db_host = ""; $db_user = ""; $db_pass = ""; $db_name = ""; I have to fill out these, so I wanted to check but I used 'ampps' to install mysql. so I couldn't f
I am newbie to python ,trying with simple programs given below is a program which i tried to get the data from table and displaying it. Installed Python3.4 and
So I have a MariaDB running on my Raspberry and I have created some Android apps that read/write data to that database. Yesterday the apps were not able to conn