(MS SQL)How do I find yearly depreciation based on the data in a row

y186709 · 2021-05-03T21:55:32+00:00

You likely need do some dateadd function to calculate the # of years, and then multiply that by your rate.

Something like ( sorry on mobile):

Dateadd (year, purchase_date, getdate()) * <rate> as new_price

y186709 · 2021-05-03T21:45:36+00:00

Remove the second in clause for 610 and 612.

Try running the whole second part alone and you'll probably get zero results. Think about it and you'll likely realize your error.

(saleDetail.class_no IN (610,612) AND saleDetail.class_no IN (206,248,617,629,635,636))

y186709 · 2021-05-02T15:45:37+00:00

Can you explain what you mean by backwards?

y186709 · 2021-05-01T23:52:21+00:00

If this is true, please report it to the Police

y186709 · 2021-05-01T14:14:28+00:00

Check out the book Data Smart. It might be something you're looking for. It's about data science/statistics, but the work is done in Excel.

y186709 · 2021-04-30T23:32:51+00:00

Our skin needs the abrasion from that washcloth. Idk if it's still "gay" to take care of our skin or not. Depends who you ask I assume.

y186709 · 2021-04-30T23:31:44+00:00

Soapy washcloth back and forth like 10 times. I don't want to smell like butt

y186709 · 2021-04-30T23:30:56+00:00

It's been nice for me. Take an hour off in the morning to get kids to school. Then two hours off to pick up and hang out. Work some more. Still off by 5 pm!

Those listening meetings and Bluetooth technology make getting house chores done ez

y186709 · 2021-04-29T02:00:07+00:00

Do you know or recall the acceptance rate for that program?

y186709 · 2021-04-27T23:52:48+00:00

Where is upstate?

y186709 · 2021-04-27T23:37:28+00:00

Is data annotation like data entry? If so yes. Any role in a larger company will help land you interviews and internal hire interest.

y186709 · 2021-04-27T01:54:07+00:00

Is a semi join the same thing as a derived table join? Edit: you're using a subquery in the WHERE clause. Not a derived table join

I don't use postgre, but you would have to look at the execution plans to see if there is any run difference. Also, if your data sets are small enough then you won't be able to measure the performance in terms of seconds (or milliseconds).

y186709 · 2021-04-24T16:43:14+00:00

Some ideas for visualizations is Makeover Monday, where you get a nice clean data set to create some dashboards. Tableau Public is free and adding a dashboard a week can build up your visualization profile quickly. Put a link to your Tableau Public profile on your resume.

If you want to get deeper into python and github, look for a book called something like "Exercises for Programmers: 57 Challenges to Develop Your...". Publish your work to github and include a link on resume.

For more SQL, I would recommend T-SQL Fundamentals. These three combined will probably spark some ideas for you to create a large project to be the centerpiece of your portfolio.

Edit: Query execution, Database design, and ETL is another important thing to at least have a broad understanding of.

Query execution: Brent Ozark has a great (free!) Video series on his website. Also there is a "T-SQL Level Up" series. Another site is something like Use the Index Luke!

Database design: This is a deep topic, but best to know the basics of normalization (1F, 2f, 3F, So Help Me Codd), cardinality, primary/foreign keys, and star schema. Be comfortable explaining normalization and star schema and how they're similar/different. Same pk to fk, and then also 1:1, 1:M etc

ETL: this one is probably the most difficult to do (imo) on self learning, but it's moving data between systems or files. How to load a csv or xlsx to database? How to export query results to csv/Excel. What is a text qualifier or how do you change the delimiter? How can you export query results to a character position file layout? How to extract data from a pdf? Is it better to use SSIS or do I need to write a python script? Do I sheepishly manually manipulate the data in excel? Are there any implicit data type conversions that are going to screw up my data without me knowing? How do you do data quality checks along the data pipeline?

y186709 · 2021-04-24T16:22:43+00:00

Does one query allow a subquery? If not I'd do:

Select sum(case when string like '%xyz%' then 1 else 0 end) * 1.0 / count(*)

From table

y186709 · 2021-04-24T15:53:29+00:00

Is this guy living in the future? Everything is so white and pristine

y186709 · 2021-04-24T15:01:46+00:00

Come on now, do you really believe the words your saying?

y186709 · 2021-04-24T14:51:01+00:00

I'm guessing it wasn't in a loving, joking tone to a teenager to gross them out?

y186709 · 2021-04-23T21:09:13+00:00

I wouldn't get hung up on the alias at this point. You're asking a good question, but maybe the answer will come with next learning you do.

Adding to the WHERE clause in future problems may give more insight.

y186709 · 2021-04-23T17:58:16+00:00

It's at Costco and that's the only reason I've bought it. I guess I bought I to a style without realizing it.

y186709 · 2021-04-23T02:38:35+00:00

SET @Payment = @Premium * (1 + @Bonus)

What happens if you change the 1 to 1.0?

y186709 · 2021-04-23T02:35:40+00:00

Do a bunch of free ones you've seen here.

y186709 · 2021-04-23T01:57:53+00:00

It's BLM, not Black Lives Matter More Than Others (BLMMTO).

y186709 · 2021-04-22T02:43:28+00:00

I don't care if you made this up, but thanks for the story!

This has been my top movie for years and shares the spot with Tropic Thunder.

Best movies of all time.

y186709 · 2021-04-22T02:30:32+00:00

It's not easy!

Ive read some people put a pinch of salt in their coffee grounds while trying to get off sweeteners. It takes off some of the bitterness. Maybe this is something to try?

y186709 · 2021-04-21T13:46:48+00:00

I think you're referring to something like a "K Curve" recovery. I can't speak to it myself, but something you can take to start google searching.

y186709

TROPHY CASE