Data Interview Qs - Calculating cost per square foot

InterviewQs

Calculating cost per square foot

SQL Database Querying Subquery Join

Forward this email to a friend or colleague and challenge them to solve it.

Hi, 

You're given the following tables that have information about a real estate portfolio. The tables provide information on building size and total cost.

Table: building_info

building_id sqft num_rooms num_bathrooms
1 40073 40 10
2 98003 98 25
3 12092 12 3
... ... ... ...

Table: building_cost

building_id rent janitorial
1 184314 2654
2 65486 1372
3 52891 2145
... ... ...

Using the tables above, write a SQL query that calculates the average total cost per square foot for each building. In the "building_cost" table you'll have to add both the rent and the janitorial cost in order to calculate total cost.

You can view/query the data in an interactive SQL fiddle here.


 

You’ve accumulated 361 questions since joining our email list. Create a premium account to access detailed solutions to each problem (including this one) + our new Case studies.


Was this email forwarded to you? You can join our list here to receive questions

How did you like today's question?

15411 Boischatel, Montreal, QC, H9H1Y7, Canada
Don't want to get these emails anymore? We'll forgive you if you unsubscribe

Key phrases

Older messages

Simulating wealth over time while playing a biased coin toss game

Wednesday, October 19, 2022

Python, Simulation, Statistics, Data Visualization, Kelly Criterion, InterviewQs Simulating wealth over time while playing a biased coin toss game Python Simulation Statistics Data Visualization Kelly

Evaluating a Tic-tac-toe game

Monday, October 17, 2022

Python, Algorithms, Data Structures, Arrays, InterviewQs Evaluating a Tic-tac-toe game Python Algorithms Data Structures Arrays Forward this email to a friend or colleague and challenge them to solve

Sample size estimation for smart watch users

Friday, October 14, 2022

Statistics, Sample Size Estimate, Z-score, Cochran's Formula, InterviewQs Sample size estimation for smart watch users Statistics Sample Size Estimate Z-score Cochran's Formula Forward this

Percent of months logged in

Wednesday, October 12, 2022

SQL, Database Querying, Subquery, WITH Statement, InterviewQs Percent of months logged in SQL Database Querying Subquery WITH Statement Forward this email to a friend or colleague and challenge them to

Foggiest months

Monday, October 10, 2022

Data Analysis, Python, Pandas, Data Manipulation, Data Visualization, External Dataset, InterviewQs Foggiest months Data Analysis Python Pandas Data Manipulation Data Visualization External Dataset

You Might Also Like

How many Vision Pro headsets has Apple sold?

Monday, April 29, 2024

The Morning After It's Monday, April 29, 2024. Apple Vision Pro headset production is reportedly being cut, sales are reportedly “way down.” But but but wait: Wasn't the Vision Pro meant to

Okta Warns of Unprecedented Surge in Proxy-Driven Credential Stuffing Attacks

Monday, April 29, 2024

THN Daily Updates Newsletter cover Webinar -- Uncovering Contemporary DDoS Attack Tactics -- and How to Fight Back Stop DDoS Attacks Before They Stop Your Business... and Make You Headline News.

Import AI 370: 213 AI safety challenges; everything becomes a game; Tesla's big cluster

Monday, April 29, 2024

Are AI systems more like religious artifacts or disposable entertainment? ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏

Apple renews OpenAI talks 🧠, Google fires Python team 👨‍💻, React 19 beta ⚛️

Monday, April 29, 2024

Apple has renewed discussions with OpenAI to use its generative AI technology to power new features coming to the iPhone Sign Up |Advertise|View Online TLDR Together With QA Wolf TLDR 2024-04-29 😘 Kiss

Architecture Weekly #177 - 29nd April 2024

Monday, April 29, 2024

How do you make predictions about tech without the magical crystal ball? We did that today by example. We analysed what Redis and Terraform license changes relate to the new Typescript framework Effect

Software Testing Weekly - Issue 217

Monday, April 29, 2024

How do you deal with conflicts in QA? ⚔️ View on the Web Archives ISSUE 217 April 29th 2024 COMMENT Welcome to the 217th issue! How do you deal with conflicts in QA? Ideally, you'd like to know how

📧 Did you watch the free MMA chapters? (1+ hours of content)

Monday, April 29, 2024

Did you watch the free MMA chapters? Hey there! 👋 I wish you a fantastic start to the week. Last week, I launched Modular Monolith Architecture. More than 300+ students are already deep into the MMA

WP Weekly 191 - Essentials - Duplicate in Core, White Label Kadence, Studio for Mac

Monday, April 29, 2024

Read on Website WP Weekly 191 / Essentials It seems many essential features are being covered in-house, be it the upcoming duplicate posts/pages feature in the WordPress core or the launch of Studio

SRE Weekly Issue #422

Monday, April 29, 2024

View on sreweekly.com A message from our sponsor, FireHydrant: FireHydrant is now AI-powered for faster, smarter incidents! Power up your incidents with auto-generated real-time summaries,

Quick question

Sunday, April 28, 2024

I want to learn how I can better serve you ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌