I have a table named "Applications" where I keep track of the applications made by my candidates to vacancies. Now, I need to write a statistical query for HRs, and when an HR logs in, I should bring the candidates…
I have two tables 'poolTemp' and 'weather'. Both tables contain the columns "timeStamp" and "tempC". I want to join the tables with both "tempC" but only when poolTime.timeStamp is within 5 minutes of weather.timeStamp poolTemp.timeStamp data is recorded up to…
I have the following query: select count(*) as aggregate from users where date(created_at) < '2024-04-01'; It returns 2337355 which is a correct number. But it takes over 1.5 secs to be executed. Any idea how can I make it more…
select productline, customerName, totale from( SELECT productLines.productline, customers.customerName, sum(quantityOrdered) as totale from customers, orders, productlines, products, orderdetails WHERE customers.customerNumber = orders.customerNumber and orderdetails.orderNumber= orders.orderNumber and orderdetails.productCode = products.productCode and productlines.productLine= products.productLine GROUP by productlines.productline, customers.customerName order by sum(quantityOrdered) desc )…
I want to create a main page for my learning site (trying to learn stuff), but I have a problem with (I think) getting response from query. HTML for getting the table what I want. Value in button is the…
we have in our system a query that supposed to filter reports based on some factors the query is indexed , and when use explain it shows like it uses the indexes but the row numbers are the same amount…
I'm looking for efficient strategies to optimize a MySQL query that generates Cartesian products in scenarios involving large data sets. The specific use case involves pairing cast and crew members for each movie in a database, which can result in…
I have a table companies in which there are some duplicated rows I found with a simple GROUP BY name. This companies table has a PRIMARY KEY id which is referenced in several other tables, under the name company_id, which…
I have a table with a JSON column. The JSON column holds for each row, a JSON array with JSON objects such as this [{"my_value": 42, "category": "A"}, {"my_value": 100, "category": "C"}, {"my_value": 15, "category": "B"}, {"my_value": 123, "category": "D"}]…
I have a function & I'm checking whether the table and column exist or not. If exits, then I need to alter the table. delimiter $$ create function column_exists(ptable varchar(300), pcolumn varchar(100)) returns CHAR reads sql data begin declare result…