Python: Count words, Count substring, Separate list of lists, Random number generator.
Data Interview Questions
132,752 data interview questions shared by candidates
Given two tables with the following columns: USERS user id date time stamp post id user action action details POST_REMOVED_BY_REVIEWER post id date time stamp report the daily ratio of posts removed by reviewers out of the user reported posts (user action = report)
SQL: 1. given table products(product_id, brand_name,product_name, product_price), find brand_names with avg price > 3 and having more then 5 products 2.given table sales (sale_id, promotion_id, sale_amount, other columns), find % of how sales with promotions ( promotion_id is null) are doing in comparison to all sales. Coding(Java): 1. find avg word length in a sentence 2. ip address validation 3. Friends problem [[A,B], [B,D],[E]...] ( List of lists);
Given a purchase table(user, purchase_time, amount_of_money, level1_category, level2_category), write a sql query to find the customer purchase in continue 7 days and with the total money greater than 500
What does SQL stand for
what do you look for a company
Describe different JOINs in SQL. Having a categorical variable with thousands distinct values, how would you encode it? How to find linear trends in time series. How to find the flow in a matrix showing temperature. ...
If you take 3 subsequent number (n, n+1, n+2) and know, that n and n+2 are prime numbers, can you proove, that n+1 is always dividable by 6?
What would you do if your manager was leaking company confidential information?
What is AUC? What lies on x-axis and y-axis of AUC curve?
Viewing 401 - 410 interview questions
See Interview Questions for Similar Jobs
Noc OperatorDatacenter TechnicianConfiguration Management AnalystCirculation ManagerComputer OperatorManager Marketing AnalyticsMedical Office SpecialistMedical Claims ProcessorMedical Billing ClerkMarketing Analytics ManagerMedical ClerkManager AnalyticsMailroom ClerkMail SorterMedical Office ReceptionistMedical Office ClerkMail Room ClerkMedical Record Retrieval SpecialistManual Software Tester