I have a table, Account, which I am querying to identify old accounts based on sales records. An account may have multiple rows in a Property table. A property may be closed. If all properties on an account are closed,…
create table A { id text, val text } create table B { val0 text, val1 text, val2 text } id and val of table A contain each a large, but discrete number of values in an many-to-many relationship. Sample…
I'm struggling with this for a while now and can't seem to figure it out. I have a clients, relations (which define relations and their type between clients) and consultations. What I wan't to do is count how many consultations…
I've made a query to count and rank every row for a table, but I can't join the query into one table. I've been trying to make a leaderboard and I've managed to make a query that ranks every row…
I'm working on a transport program that forces me to create a long query to search for possible routes. I need to optimize the query as much as possible. It calculates stopovers between bus stops. People get off at one…
Assume I have two tables: cameraNum roadNum isWorking 100 1 TRUE 101 1 FALSE 102 1 TRUE 103 3 FALSE 104 3 FALSE 105 7 TRUE 106 7 TRUE 107 7 TRUE 108 9 FALSE 109 9 FALSE 110 9…
I can't get the REPLACE function to work on my SQL command shown here. I want it to take my search term (55512) and search for this in the field using the modified field from the regexp to remove all…
In Postgresql, suppose I have a 2-col table containing 3 records, namely tA id | col_A | col_B | type 1 | 1 | 2 | A 2 | 3 | 4 | B 3 | 3 | 1 |…
My query goes over three entities, so I have two left joins. I want to restrict the result of the first join. For example we have customers and order evaluations. In the first join I want only the youngest order…
On running the following MySQL (5.7.12) UPDATE statement, I get the error "Error Code: 1054. Unknown column 't1.col2' in 'where clause'". How can I rephrase this query such that the columns of t1 are accessible in the subquery? UPDATE MyFirstTable…