MonthName Calendar_Year Total Number Moving Average 5 Year Moving Average 10 Year April 2000 135 April 2001 76 April 2002 33 April 2003 31 April 2004 228 April 2005 200 101 April 2006 350 114 April 2007 126 168 April…
I have a stored procedure returning a table. Is it possible to have the same output in a view instead of a stored procedure? Is there any way to return the function in a view? CREATE PROCEDURE `getReservedDevices`(IN `location_id` INT(11),…
I have a table listings with a jsonb column named data. Inside the data column I have the next structure { "attributes": { "listings": [ { "vin": "a", ... }, { "vin": "b", ... } ] } } I am…
The database used is PostgreSQL. I have a query that combines two tables and does a where search on some category and then does order by by some property. The table products has a 10+ million products. If I put…
I have a PostgreSQL table which gives me the following output: country metric_code male female pensioners teenagers us metric_1 10 14 22 30 us metric_2 105 142 222 309 uk metric_1 15 13 9 21 uk metric_2 212 264 440…
I want to use a column of arrays as a condition in postgres. The condition is applied on a column composed of text value. This is the column made out of arrays (after be transformed with string_to_array. And this is…
I have a table called phones with a column like this where items here are repeated brand Google Samsung Apple Hydrogen Nokia Itel Honor Huawei and I want to use either the LIKE keyword or the regular expression in MySQL…
I have a csv file which I loaded into MySQL after creating a database and a table (phones). The columns of the table among others are: state and phone_condition. Also, I have ran many queries which were successful; but this…
I'm adding data to a MySQL 8 database on PythonAnywhere. I'm doing this via a python 3.10 script run in VSCode using an SSH Tunnel. When I add the data it takes approximately 50 seconds to add 275 rows, data…
I have a search query where I am getting records from 2 tables Table A gives client data , Table B gives transaction number clientdid is PK in table A and FK in table B . I am using left…