Skip to content

create an sql command to do the data cleaning and column formating as the requirements. #upwork

Notifications You must be signed in to change notification settings

ssuwijak/data-01

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Simple Query for Data Cleaning

create SQL queries to get the result as the sample data in Excel. that is, sample data and expected result

  1. consider the oz and ct word.
  2. if oz or ct are not found, it shows 0 (zero), else 1 (one).
  3. consider the NetWeight.
  4. the database is SQLServer.

SQL query and result SQL query

SQL command to create a table

About

create an sql command to do the data cleaning and column formating as the requirements. #upwork

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages