21032024

Displays the count of certified case status for every job title, sorted to show the highest certified count to the lowest.

This query will retrieve the specified columns from the public.jobs table, filtered for cases with a status of 'Certified', ordered by the most recent received_date, and limited to the first 100 rows.

Query of table Jobs

The state with the highest H-1b Visas

Jobs with 'analyst' near VA - includes NC, VA, DC, MD.

Number of employees per country

500$ challenge

Sort 500$ challenge

Top 10 job titles with the highest number of cases

job_title='Software Engineer'

Data analyst

Best Job titles sorted from best to worst.

Count the number of cases for each visa class

Count of Job_titles

Selects Top 100 rows of Business Analysts who are Certified(case_status certified)

This query gets the number of full time jobs and cases associated that were certified along with the number of cases that fit the above criteria for the state of TN.

Gets the number of jobs under Standard Occupational Classification title and cases that were certified for full time jobs. It adds how many cases were in TN state.

Lists companies which are within [3000] postal code units of their attorney alphabetically.

Conversion rate of H1B applications

list of data jobs

list of data jobs

Jess Ramos Test

comparing jobs

This shows how many visas were denied in 2023 by SOC title.

List the Different Case Status of the H1B Visas.

duplicate case_number

counting jobs by job grouping

Jess Ramos SQl challenge query

Record count by employer_name

Identifies companies which are situated within 500 postal-code units of their attorney. Lists companies by ascending postal code..

This query lists all the employees with a "Manager" job title.

check the number of entries in each visa class

List of candidates in Cupertino

Query to show 10 records of the table.

This query shows the list of all those whose employer country is Birmingham and they are ordered in ascending order of their case_id

What are the 'soc_title' with their respective 'visa_class' with more than 10,000 'Certified' status

1 select * from public jobs where = Data Analyst

Number of Full Time and Not Full Time IT Professionals

Latest Developers with H1Bs

case expression

Test Query

This query selects the columns case_number, case_status, received_date, decision_date, visa_class, and job_title from the "jobs" table in the "public" schema. It filters the rows where the visa_class column equals 'H-1B', orders the results by the job_title column in ascending order

Find the number of certified cases in the year 2023 for each employer state. Show the name and the number of certified cases in the result. Show the final result in descending order of number of certified cases.

Case number- with group by

Find count of h1b cases certified in the year 2023 for each state, and group the result by the name of the employer state. Finally order the result in the descending order of the number of cases certified.

listing top 100 columns where the visa class is not equal to H-1B

Analysts job title

case numbers that have worksite state as Texas and worksite city as Houston with potential starting salary equal to or greater than $50,000. Ordered by wage in descending order.

It filters the results to only include jobs located in CA and with a wage rate greater than $100,000.

Hope it be user friendly and lively community

SQL

Fetch rows where by the job title contains the word "Data"

This query gets the data of those whose employer is Google and it is in ascending order of their case_number.

This query gives state wise count of professionals working in data related roles wose H1B case status is 'certified'.

preview of the table using LIMIT clause

Number of cases in each Visa-Class.

Query to find the cases valid for year 2024 without duplicates

all rows where job is some kind of "SOFTWARE DEVELOPER"

Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅

Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅

Select the last record to have a decision.

Selected first 10 records, all columns

This query outputs the 3 job titles with the most open positions by state.

Dyna Kheang

Top employers sponsoring H1B cases

job title, employer name, wage from

SELECT orders.*, customers.* FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id;

SELECT orders.*, customers.* FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id;

Used a query to select case_status

Ran a query to view all the decisions dates from the public.jobs table