I have a Users table (id, name, created_at) and a Transaction table(id, user_id, created_at, amount). For each month, I would like to know the number of users who did not have any transaction in the 3 months interval before that…
Why must I state the table I'm referring to TWICE when using a join on a query? select table1.name from table1 inner join table2 on etc ...
I have below tables DEMO fiddle In x_table, I have different records. I want to fetch all currencies from x_table where continent is Asia which is straight forward as below, SELECT currency from x_table where continent='Asia' and it should return…
I had to get the town name and state from database which deployed the first reciever(a device to sense sharks). I used the following query with a subquery computing MIN of deployed dates: SELECT t.town,t.state,r.deployed FROM receiver as r inner…
Am trying to select join record from TABLE_USER_MATCHES if the uid, is not the one that created the match m_from. My intention is to join records from TABLE_USER_MATCHES if it exist and it's not created by m_from p1 and also…
I am using PostgreSQL 9.5 I have two table: A ID | isStatusA | IsStatusB | IsStatusC 0 | true | false | true A table has only 1 row for data i need. Also i have B table with:…
I want to export some data from the DB. Basically what I want to say is this: 1- Select mbr_name from the members table 2- Choose the ones that exist at the course_registration table (based on mbr_id) 3- Join the…
I have two related tables like below : Users : public partial class Users { [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")] public Users() { } public int ID { get; set; } public int UserType_ID { get; set; } public string Email { get;…
I want all the 'acteurs' of a table in the value of a option, but I don't know how to. I have two tables, 'auteurs' and 'posts'. In the posts table I have a column named 'auteur_id' that has a…
I have to need a project school, a site like ebay with bid. I have to make a select who select the name of the seller the name of the last "customer" (bid) BUT THE PROBLEM is that there two…