I am struggling with SQL in R studio. There are 12 variables from…

Question I am struggling with SQL in R studio. There are 12 variables from… I am struggling with SQL in R studio. There are 12 variables from sqlite file. I think I should say table name(?) So there are 12 tables in sqlite file.  This is the questions that I need help with. #1,3Image transcription text1. What is the date range for thequestions and answers in thisdatabase? 2. How many u… Show more… Show more For #2, I used dim(users) so I found the how many users or if I did wrong then please correct me. and for the Users, Image transcription text51 dbListFields (con,”Users”) 52dbListFields (con, &… Show more… Show moreThere are 13 variables.  So for Question 3, I try to find number of users with dbGetQuery function but result is not what I want. Image transcription text72 playerinyear = dbGetQuery (con,paste(“SELECT CreationDate,COUNT(DISTINCT Id) AS… Show more… Show moreHere is the result.  As you can see, there are several data in each day(each user in different time). I want to get table look like this.Image transcription text2006 1242 2007 1278 2008 1291 20091266… Show morenumber of joined users each year.  I think I need make the function that count number of joined users only in the year that I want but I am not sure how to make function using in sqlite.  I want to access only for the specific year that I want in CreationDate.   Math Statistics and Probability STA 141B Share QuestionEmailCopy link Comments (0)