Please note I’m a beginner in SQL and PHP and I search =every where but didn’t found anything useful I want to select two data from the following table. id name 1 Joe 2 John my code else if($_SESSION[‘name’]==’Joe’) I tried use this syntax but didn’t work ==’Joe’, ‘John’, ==(‘Joe’, ‘John’) Please help me >Solution… Read More How to select two or more element in SQL table?

I’m pretty new to SQL and am struggling to get the syntax/logic correct for what I need. Right now I have a query ending in a where statement: WHERE business IN (‘A’,’B’,’C’) AND CASE WHEN queue = ‘Q1’ THEN (queue = ‘Q1’ AND queue_type = ‘Y’) END Basically I need all the results, except for… Read More SQL: Making a conditional WHERE clause?

If I launch this insert twice, it adds duplicate products to me. how do I add if something has changed? INSERT INTO db1 ("Drink") VALUES (‘Cola’), (‘Rom’), (‘Sprite’), (‘Fanta’), (‘Vodka’); >Solution : INSERT INTO db1 ("Drink") select drinks.drink from ( VALUES (‘Cola’), (‘Rom’), (‘Sprite’), (‘Fanta’), (‘Vodka’) ) as drinks(drink) where not exists (select 1 from… Read More If I launch this insert twice

I have 2 tables PLAYERS and GAMES When a new game starts, I add a new GAME record with a playerID to the database, so the data might look like this: GAMES Id  Score PlayerId 1   200    10 2   100    10 3   500    10 4   100    11 5   200    11 Question: How do I query this if I want to get the highest score and sum of… Read More SQL How do I get highscore and number of rows as attempts

I have a table Time with column StartTime: ID StartTime 1 08:00:00 Now I want to find the time difference between StartTime and 09:00:00, divide it by 3 to result in 20min. How can I do something like this? SELECT (’09:00:00′ – (SELECT StartTime FROM Time) / 3) Output should be ’00:20:00′ >Solution : A… Read More How to divide hour to minute in MySQL?

How could I select * from table movies where seeds > 10 in table torrents? Table movies has unique id, while table torrents has id that matches the movie id. There are few torrents for each movie and having just one that has seeds greather than 10 should be selected. The only sql I have… Read More How to select from table where value from another table is greather than some value?

I’m learning SQL and one of the questions that got thrown at me in my solo study suddenly is to write a script in order to count how many of each gender is in the client table, Table CLIENT: ClientID `First Name` `Last Name` Gender ID `Birth Date` 1 Sally Fields 1 03/05/2000 2 Hannah… Read More Learning SQL, trying to figure out how to get a gender count

Trying to join 3 tables in order to segment customers who either opened or clicked in an email within the past year. I have tried the below query a multitude of different ways and am always getting a syntax error ‘Incorrect syntax near the keyword ‘Left” when trying to incorporate the EventDate in my Where… Read More SQL Error Incorrect syntax near the keyword 'Left'

I’m trying to get the minimum value of open, across multiple rows of year. This is from app.mode.com and the site only says SQL, not sure which version SELECT year, open FROM tutorial.aapl_historical_stock_price WHERE open = (select MIN(open) FROM tutorial.aapl_historical_stock_price) When I use the code above, the result is Table result vs actual output |… Read More SQL/ Return MIN values of multiple rows

Here is the DEMO for better understand what is the issue. The following sql query prints only the ones with the mp3 value of the uploaded_file_ext in the i_user_uploads table. As can be understood from the query, the data in i_user_uploads is taken from the post_file ids in the i_posts table. I need to make… Read More FIND_IN_SET() After checking the id's it's acting like it's two different posts