Given a currency table I need to find the latest record of conversion rate which is less than given particular date Input table structure given below: id baseCur Curr rate date 1 INR USD 81 2022-11-09 2 INR USD 82…
I have a dataframe like this Value. Date A 08/08/2009 A 09/12/2021 A 05/10/2022 A 06/09/2022 A 07/08/2022 I need output like VALUE DATE A 05/10/2022 A 06/09/2022 A 07/08/2022 We have to print a latest year with all month…
I'm trying to import a .csv file to MySQL using the table data import wizard, but I keep getting this error. Could someone explain what this means and how I would go about fixing it.
I am trying to open a random .sql file off the internet using the following command: psql -h localhost -d database_name -U postgres < file_name.sql But when I run this command I just get errors like the following: invalid command…
How to read JSON object matching query params? I want to filter data for video urls which only contains query params from metadata column and replace it by the removing the query params. metadata {"video-url":"xyz.com/video/xy4jnj?pubtool=oembed","provider":"some-video","video-id":"x8cse6q"} {"video-url":"xyz.com/video/x8cse6q?pubtool=oembed","provider":"some-video","video-id":x8cse6q} {"video-url":"xyz.com/video/x8cse6q","provider":"some-video","video-id":"x8cse6q"} select * from…
select count(memberid) cnt from memberdata where MemberID; select count(Deleted) UnUsable from memberdata where deleted = 1; select count(Deleted) Usable from memberdata where deleted = 0; Question How to make this query to one?
Please I have a table structured this way. Number Parent 1 NULL 2 1 3 2 I want to carry out a SQL Query that goes through the rows and for each row outputs one of two values for the…
I have a MySQL table of users as follows: CREATE TABLE `users` ( `ID` INT NOT NULL, -- NOTE: in practice, I'm using BINARY(16) and -- the UUID()-function to create user IDs. -- 'INT' is only a simplification for this…
`mysql> select * from movies; +----------+-------+---------+ | movie_id | title | watched | +----------+-------+---------+ | 1 | bo | 0 | | 2 | NEW | 0 | | 3 | NEW 2 | 0 | +----------+-------+---------+ CREATE TABLE MOVIES…
I'm having a problem in where i want to count how many medals in total a country has won from both the individual and team competitions does not give me the disered outcome. i have managed so far tocome up…