Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started
Dataford
Popular roles
Software EngineerData AnalystData ScientistData EngineerBusiness AnalystAI EngineerMachine Learning EngineerProduct Manager
Browse
Browse All RolesEvery role hub, from analyst to MLBrowse All CompaniesCompany-specific interview loopsAll Interview GuidesThe full guide library
Top questions by role
Software EngineerData AnalystData ScientistData EngineerBusiness AnalystAI EngineerMachine Learning EngineerProduct Manager
Top questions by skill
SQLPythonStatisticsMachine LearningA/B TestingSystem DesignGenerative AIProduct SenseMetricsBehavioral
Browse all questions →Try a mock interview
Experiences
Practice
Mock InterviewsTimed interview simulations with feedbackSuccess PathYour 6-week structured planModulesCurated lessons by topicWebinarsTalks from ex-Big Tech data leadsPlaygroundA free-form scratch editor
Learn
BlogInterview strategy and career adviceTech Job Market ReportHiring trends across data and AI rolesFor UniversitiesDataford for career centersAbout DatafordWho we are and how we build
Pricing
Build my plan
SQL and Tableau Usage
00:00
5 left

SQL and Tableau Usage

MediumSQL · PostgreSQL

Problem

How have you used SQL and Tableau in your work thus far?

Use the supplied records to demonstrate that experience with a concise usage summary. Include analysts with no recorded activity and classify each analyst according to whether they used SQL, Tableau, both, or neither.

Output

  1. One row per analyst, including analysts without matching activity records.
  2. Columns: analyst_name, sql_query_count, successful_sql_query_count, average_runtime_ms, tableau_asset_count, published_tableau_asset_count, and tool_usage_category.
  3. Sort by analyst_id ascending. Classify usage as Both, SQL only, Tableau only, or Neither.

Schema

analysts
ColumnTypeDescription
analyst_idPKINTUnique analyst identifier
analyst_nameVARCHAR(100)Analyst display name
sql_runs
ColumnTypeDescription
run_idPKINTUnique SQL run identifier
analyst_idINTAnalyst associated with the SQL run
statusVARCHAR(20)SQL run status
runtime_msINTSQL runtime in milliseconds
tableau_assets
ColumnTypeDescription
asset_idPKINTUnique Tableau asset identifier
owner_analyst_idINTAnalyst who owns the Tableau asset
asset_nameVARCHAR(150)Tableau asset name
is_publishedBOOLEANWhether the asset is published
Tablesanalystssql_runstableau_assets
Interviewer

Your question is SQL and Tableau Usage. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.
CodePostgreSQL
Sign up free to run your codeLog inLn 1
Run your query to see results here.