Given two tables Friend_request (requester_id, sent_to_id, time) Request_accepted (acceptor_id, requestor_id, time) Find the overall acceptance rate of requests.
Datos Interview Questions
89,568 datos interview questions shared by candidates
Write a sql query to find out the overall friend acceptance rate for a given date? Table :- User_id_who_sent|User_id_to_whom|date|Action (Sent, accepted, rejected etc)
Given the following tables how would you know who has the most friends REQUESTS date | sender_id | accepter_id ACCEPTED accepted_at | accepter_id | sender_id
1) Provided a table with user_id and dates they visited platform, find the top 100 users with the longest continuous streak of visiting the platform as of yesterday. 2) Provided a table with page_id, event timestamp and a flag for a state (which is on/off), find the number of pages that are currently on.
There is a table that tracks every time a user turns a feature on or off, with columns user_id, action ("on" or "off), date, and time. How many users turned the feature on today? How many users have ever turned the feature on? In a table that tracks the status of every user every day, how would you add today's data to it?
No questions were difficult
Behavioral questions probing about fit
Write a function that takes in two sorted lists and outputs a sorted list that is their union.
They asked probability question: 1) The probability that item an item at location A is 0.6 , and 0.8 at location B. What is the probability that item would be found on Amazon website. 2). I have table 1, with 1million records, with ID, AGE (column names) , Table 2 with 100 records with ID and Salary then the interviewer gave me the following SQL script SELECT A.ID,A.AGE,B.SALARY FROM TABLE 1 A LEFT JOIN TABLE 2 B ON A.ID = B.ID + WHERE B.SALARY > 50000 ( HE ASKED TO MODIFY THIS LINE OF QUERY) How many records would be returned? 3. Give a csv file with ID, and Quantity columns, 50million records and size of data is 2gig, write a program in any language of your choice to aggregate the QUANTITY column.
100 even number in ascending order first 50 number average is N then all the number average is a N+49 B N+50 C N+55
Viewing 11 - 20 interview questions
See Interview Questions for Similar Jobs
MetadatosGobernanza De DatosInforme De DatosAnaliticoDatos De EntradaData DirectorPasante De Análisis De DatosJefe De DatosAdministrador De Análisis De DatosAnálisis De DatosOficinista De EscaneoAnalísta De Datos JuniorProcesador De DatosAnalista De Datos JuniorVisión De DatosAnalytics SpecialistAnalistas De DatosAdministrador De Datos Junior