Suppose, we've a table named college. In this database we've the following columns: College ID, College name, State and Established in. Now I want to find the names only of those colleges where the college have another branch in the…
can anybody help? there's a table containing data about games...including: name VARCHAR(255) platform VARCHAR(255) year_of_release YEAR genre VARCHAR(255) publisher VARCHAR(255) na_sales DOUBLE(10,2) other_sales DOUBLE(10,2) global_sales DOUBLE(10,2) when i run this query: select Name, Year_of_Release, Other_Sales, Global_Sales from ( select *…
I have this table, in the left there is the sample input table and on the right desired output How to calculate the number of status per empid basis using SQL on MySQL.
I have a table like this in Postgres: user_id project status 1 p1 finished 2 p1 finished 2 p2 finished 2 p3 finished 3 p1 finished 3 p2 finished 3 p3 finished 4 p1 finished 5 p1 finished 6 p1…
I'm learning SQL and have come across a problem that needs a self-join. I've been playing around with the query to understand why the self-join table lays it out the way it does, but haven't had much luck Create table…
In mySQL, have a large table of history data and I am looking for an elegant way to be able to select the earliest/latest event types in a single select statement without grouping by Item and Event type and running…
How can I use a parameter within a JSONPath expression in a PostgreSQL SQL query? I want to query something like this: SELECT * FROM table WHERE jsondata @@ '$.pathto.array[*].** ? (@.someproperty == ":VALUE").anotherproperty != null'; I tried: SELECT *…
I am using postgresql and I am storing recipe data. Each recipe could have up to 200 nutrients associated with it, but it must have these nutrients not null - kcal, carbs, fats, protein other than that it might or…
I'm taking beginner postgres online course and below is the question and sample answer. But I'm wondering if I can use MAX instead of ORDER BY DESC? Question: What customer has the highest customer ID number whose name starts with…
I have a table customer. The table has columns cust_id, member, date. The cust_id is a primary key (auto-increment), member can have either 1 or 0 and date contains the timestamp. I want to run a query on MySQL which…