Posts

Showing posts with the label Work from home jobs

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Top 20 highest paying working from home jobs

U.S. businesses will spend half a billion dollars hiring remote freelance workers in 2014. "The growth is a clear indicator of a transition of work online," says Fabio Rosati, CEO of Elance-oDesk. The company's platform — which serves as a broker between companies that need skills and freelancers eager to supply them — sees 2.7 millio n freelance jo bs posted a year. According to Elance-oDesk , the total earnings of freelancers have grown 50% compounded annually over the past five years. From Rosati's perspective, so many businesses are hiring these workers because they need work done on demand, typically for a short stint. In those cases... Read more