Sql combine columns from two tables jobs

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column ...

I'm seeking a skilled content writer to craft a detailed and informative article about coffee tables. The piece should be around 1,200 to 1,500 words and cover various aspects of coffee tables, including their history, different styles and designs, and material options. Moreover, I need the article to highlight the distinctions between residential and commercial coffee tables. Key points to consider: - Research and include the origin and history of coffee tables - Discuss popular styles and designs in the contemporary market - Elaborate on the differences between residential and commercial coffee table considerations - Write in a style that's accessible and engaging for a general audience - Must contain 3 to 5 links as references within the article, t...

I'm seeking a skilled designer who can create a multiple business logos from WWII era vintage-styled military art combined with modern day technology. It should be crafted in color, eliciting a classic yet modern feel. If you specialize in vintage designs and or blending multiple design elements together, this project may be an excellent fit for you. Key skills required: - Expertise in vintage logo designs - Creativity in using abstract geometric shapes - Ability to work with color palettes.

We have a non-trivial design built in Figma. We need a WordPress theme built to match that design. The desktop version is ready. This job also includes building the mobile version, according to what our designer will create soon in Figma. See the attached document for our requirements, as there are some details there.

I am in need of a versatile video editor who can create engaging and captivating YouTube Kids videos. Add sound effects and animation where needed. Key Responsibilities: - Edit and enhance video content for educational, animated, and music videos - Incorporate suitable cartoon effects, sound effects, and background music - Ensure ...between 20-40 minutes in length Ideal Candidate: - Proficiency in using cartoon and sound effects, as well as selecting suitable background music - Ability to create engaging content that captures the attention of young viewers - Capacity to deliver high-quality, polished video content within the specified length Payment will be done per video. We will provide you with the videos and you have to combine them together, add sounds you have, add effects...

...introduces the reader to the world of large conference tables. This article should be between 1,200 and 1,500 words, and provide a mix of information and benefits that really sells the concept of these tables. Key Points to Cover: - Introduction to different types of large conference tables available in the market - Factors to consider when choosing the right large conference table - Benefits and advantages of utilizing large conference tables in a professional setting - Article needs to reference l3-5 links which will be provided upon awarding the project The target audience for this article is general, so the content should be approachable and informative to all readers. The tone should be professional and engaging, keeping the reader interested from...

I'm seeking a skilled writer to draft an informative article about round conference tables. The piece will be aimed at a general audience, therefore, it's imperative that the content is engaging and easy to understand. Key Points: - The primary focus should be on educating readers about the unique benefits and features of round conference tables. - The article should highlight the distinctive qualities of round tables in comparison to other shapes, particularly emphasizing how these tables promote communication and collaboration, and their versatility in seating arrangements. - Article should be between 1,000 to 1,200 words - Article needs to contain 3 to 5 references to certain websites, which will be provided upon awarding of the project Ideal Ski...

...and informative article about square conference tables. The article will serve as an informative resource for a general audience. Key points that should be covered in the article include: - Different designs and styles: The writer should explore the various design options available for square conference tables, discussing contemporary, minimalist, classic, or any other popular styles in the market. - Benefits and features: The article should highlight the practical and aesthetic benefits of choosing a square conference table over other shapes. This could include space-saving benefits, visual symmetry, or ease of communication between participants. - General information: The writer should provide a comprehensive overview of square conference tables, including their ...

We are looking for an experienced Flutter developer to join our team and help finalize our ride-hailing application. The app is nearly complete, but we need assistance in implementing and refining our two-way communication system within the match-making component. The ideal candidate will have a strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs or performanc...

I am looking for a skilled programmer to develop an interactive chemistry experiment for me. You may code using JavaScript, HTML5 or using Python, so experience or proficiency in this language is crucial. Key Requirements: - Users should be able to drag and drop ...adjusting quantities and temperatures. If a user pours something in a beaker, it should show the beaker full. If emptied, beaker is empty. - Vector images of lab equipments like Test tube, beaker, burner etc can be found online. Ideal Skills: - Proficiency in Python or JavaScript. You may use CreateJS libraries. If you are a programmer with a passion for chemistry, this is a great opportunity to combine your skills in programming and knowledge of chemistry. I'm excited to see the creative and educational experime...

I'm seeking an expe...creation of customized work items. The chosen freelancer should have: - Solid experience in 3D modeling and printing - A deep understanding of working with plastic materials for 3D printing - Strong design abilities to deliver unique, functional appliances Your task will primarily involve transforming simple concepts into tangible, usable items. From initial design to final product, your role is pivotal to creating one-of-a-kind home appliances that combine form and function in new and exciting ways. This project is perfect for those who enjoy rethinking design norms and creating unheard-of items that will surely stand out. Samples of similar work are requested for review. Your creativity and technical skills in 3D printing will be essential to t...

I'm looking for a data entry specialist to extract text data from scanned documents and input it into a database. Key Requirements: - Data Entry: Your primary task will be to accurately transfer text data from scanned documents into a digital database. - Attention to Detail: Precision and accuracy are essential to ensure the database is error-free. - Timeliness: The task should be done in a timely manner to keep the project on track. Ideal Skills: - Proficiency in English: Since the data is in text format, a strong command of English is necessary. - Data Entry Experience: Previous experience in data entry is a plus. - Familiarity with Database Management: Basic knowledge of database operations is a bonus. Looking forward to your bids.

This project involves cleaning up an MP3 audio file. Key requirements are: - Experience with audio editing and noise reduction - Expertise in removing embedded sounds, particularly the echo and piano sounds which are equally distributed throughout this file - Delicate handling is needed as the given audio file has low quality (distorted or noisy) - Ability to complete tasks within deadlines - Experience with handling audio files of less quality like this one will be favorable - Should have access to high-quality audio processing and editing software to deliver optimal results.

I require professional support in aiding my design and create a stunning newsletter with custom banners...yet professional newsletters and banners. - Reflect the Telekom Malay branding, using the provided guidelines and color schemes. - Combine a striking aesthetic with a clean and precise style. Ideal Skills & Experience: - Proficient in graphic design software. - Proven experience in digital design, especially newsletters, and banners. - Knowledge of Telekom Malaysia branding is beneficial but not necessary. - Exceptional eye for detail and design aesthetics. - Adherence to design guidelines. - Ability to work within tight timelines. By completing this project, you will be contributing to a powerful, cohesive brand experience.. Looking forward to receiving bids from ...

I am looking for a freelancer who can help me implement a meta ad service on Facebook Ads. Target Audience: - I have a specific demographic in mind for my ads. Budget: - My expected budget for this service is less Skills and Experience: - Experience in implementing meta ad services on Facebook Ads - Strong understanding of targeting specific demographics - Ability to work within a limited budget

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous ...messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to del...

I'm looking for a data entry specialist to extract text data from scanned documents and input it into a database. Key Requirements: - Data Entry: Your primary task will be to accurately transfer text data from scanned documents into a digital database. - Attention to Detail: Precision and accuracy are essential to ensure the database is error-free. - Timeliness: The task should be done in a timely manner to keep the project on track. Ideal Skills: - Proficiency in English: Since the data is in text format, a strong command of English is necessary. - Data Entry Experience: Previous experience in data entry is a plus. - Familiarity with Database Management: Basic knowledge of database operations is a bonus. Looking forward to your bids.

Hi, Looking for a person to create an spread sheet monthly for sales records during that month. Will need to take information off of individual sales order sheets/emails and transfer it onto a spread sheet... buyer/address/item(s) they bought/amount they paid etc. Will be a reoccurring task per month. Will pay per month, expecting 100-200 sales per month. Please show rate per entry.

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

...heritage through interactive digital art. Requirements: -Proficiency in Blender for 3D modeling and animation, with a strong portfolio showcasing relevant work. -Experience in scripting within Blender to automate tasks and enhance animation functionalities. -Knowledge of integrating Blender projects with other software for interactive displays. - Demonstrated ability to work on projects that combine art and technology, particularly in public or large-scale settings. Deliverables: A series of high-quality anamorphic animations designed in Blender, ready for public display. A backend system for content management that facilitates easy updating and interaction handling. Comprehensive documentation on managing and updating the display content, as well as troubleshooting common...

I need a reliable professional to help me with monthly inventory updates from the dealers and the sales department. Key Tasks: - Quantity Update: Ensure all stock levels are accurately reflected in our records. - Product Description Update: Make sure all product descriptions are up-to-date and accurate. - Product Code, UOM (Kit/Vials), Rupee Value: Cross-check and update product codes, Unit of Measure (Kit/Vials) and Rupee Value accordingly. Format: I have a specific format that the inventory updates need to be in. You will need to use this template to ensure data consistency and compatibility with our existing systems. Frequency: This is a monthly task and I would need your support on an ongoing basis. Ideal Skills: - Proficiency in inventory management. - Attention to detail ...

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...

I need an electronic signature created from a JPG as soon as possible. This signature will be used for signing documents, email communications, and physical printouts. can pay 15 CAD

I am looking for a capable freelancer to develop a chemical reaction generation model. The goal is to do retrosynthesis, so basically predicting reactants from every SMILES product on my test data. You can use whatever you want(pre trained models or you own script)

I need someone to extract the data from a PDF file and build it into a Word document. The purpose of this is to make the content editable. - The PDF is simple, with only text and no complicated layouts, images or tables. - I would like the extracted text in the Word document to have a specific formatting style applied where headings are large, words are small. Ideal candidates should have experience with PDF to Word conversion, and possess skills in editing and formatting. Being detail-oriented is a major plus. Please note that the extracted content must be accurate and the final Word document should maintain a professional finish. Do NOT deliver this as a simple export because I could easily do that. Run grammar checking for English (Australia)

PLEASE DO NOT SEND AI DESIGNS A 2D PLAN IS A MUST Seeking a talented interior designer to create a modern and stylish residential bedroom. Key Requirements: - Proficiency in residentia...talented interior designer to create a modern and stylish residential bedroom. Key Requirements: - Proficiency in residential interior design - Strong understanding of modern design principles - Experience in creating bedroom interiors The room will have the following 1. King size bed with 2 side tables 2. Large him/her walk-in closet 3. Desser table, for him/her 4. Tv unit – to be opposite to bed Please note 1. room height is 300cm, there is a concrete slab in the middle, the height from floor is 250cm 2. the room has 3 windows, any of these windows can be canceled to ma...

...humorous designs for T-shirts - Create innovative and quirky designs with an insider IT perspective - Collaborate with me to ensure that the designs appeal to our target audience and align with our brand image Experience & Skills: - Proven experience in graphic design and expertise on design software and technologies. (Only Basic understanding of IT) - Strong aesthetic skills with the ability to combine various colors, fonts, and layouts - Understanding of the IT industry, its jargon, and unique humor will be a plus - Ability to take constructive feedback and turn it into a better design - Excellent communication skills are a must. This is an exciting opportunity to leverage your design expertise for a fun and creative project. Looking forward to your proposals. Let'...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

ONLY 1 COMPONENT IS NEEDED I'm in need of a skilled developer to help me design the layout of my office room using Nuxt & Vue. Key Requirements: - Implement a visual room skretch using Nuxt & Vue. This feature will help us in our daily work by quickly identifying which meeting rooms & places(tables) are occupied and which are available. Ideal Skills & Experience: - Strong experience in Nuxt & Vue is essential. - Experience with creating interactive and user-friendly features in web applications. This project requires creativity and an understanding of office space optimization. A successful implementation will result in a more efficient and productive workspace.

I have website backup which needs to be restore and fix its pages to be in working condition. there are 6-8 pages in total and its simple website. Fixed Budget: 10$

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into compr...

We need people, as many as possible from the UK and AU to shoot a UGC video on how our product cleans your teeth. Here is an example: Here is our website: **Who we need based on our target audience:** - Female and Male between 35-44, (Mostly Female) - Mostly have a family and childrens or family oriented - Possibly a smoker or regular coffee drinker. **What we need:** - Make a Video about using our product for a few days using our scripts, you can come up with your own but basically we will provide everything. **From us:** - 50-70$ for a ready edited video 60 seconds long. (we can do the editing ourselves) - Our product you will keep and you can

I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.

I need to have a girl removed from a short, high-definition video of myself and my sister. The video is less than a minute long. The girl to be cropped out is positioned in the middle of the video and I want the edited outcome to feature just my sister and I. Key tasks include: - Identify and crop out the girl from the video - Ensure smooth transition and maintain overall video quality - Final video should be in high-definition Skills and experience necessary: - Proficiency in video editing software (Adobe Premiere Pro, Final Cut Pro...) - Ability to crop out individuals effectively and smoothly - Experience with transitional effects may be necessary - Attention to detail and creativity.

...contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integrity. - Attention to detail: Given the complexity of the layout, a keen eye for detail is crucial. Every eleme...

...involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(l...

I have a photo where I would like to remove a person who is on the side. (Want to keep only the girl in the black shirt) remove the other one on the left of her Key requirements: - Remove the person on the side of the photo while keeping the background intact. The background is mixed, with some areas more complex than others. It's essential that the background maintains its original look, even after the person is removed. - The final use of the edited photo will be for personal use, so the editing needs to be of a high quality. Ideal freelancer: - Previous experience in photo editing, specifically in object removal while maintaining the background. - Proficiency in tools like Photoshop or similar software. - Attention to detail and ability to deliver a high-quality output.

I have a project that involves creating a custom website. The website will be a product catalog for windows, with a design similar to quartzluxurywindows.com. AND a 10 pages Product Brochure/booklet from a sample hardcopy Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category. Optional: - Knowledge of

I have a project that involves creating a custom website. The website will be a product catalog for windows, with a design similar to quartzluxurywindows.com. Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category. Optional: - Knowledge of SEO best practices to ensure the website is search engine friendly. - Experience with...

I'm looking for someone to convert a PDF document into a Word document. The main purpose of this conversion is to extract text from the PDF content which has complex formatting, including elements such as tables and footnotes. Key Requirements: - Accurate Extraction: The primary goal here is to ensure that all text is accurately extracted from the PDF file and transferred to the Word document without any loss or distortion. - Formatting Preservation: While the layout may be complex, I'm looking for the freelancer to maintain the font styles and sizes as they appear in the original document. The ideal candidate for this job would have: - Proficiency in PDF and Word processing tools - Experience with maintaining formatting during content transfer - Attention...

I have a Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word

I'm seeking a skilled professional who can help me with a malware issue affecting multiple websites I own. - All my websites are experiencing the same type of malware. - The primary issue I'm facing is the presence of the malware on the websites. The ideal candidate for this job should have the following skills and experience: - Proven experience in malware removal and website security. - Familiarity with various malware scanning tools. - Implement security measures to avoid future attack

...hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Perso...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

...Scheme: The logo should primarily feature the colors black, white, and/or red. You can choose to combine these in various ways, keeping in mind the overall theme and style. All colors do not have to be included. - Symbolism: While the logo does not necessarily need to include roller skates, incorporating them in an innovative and creative manner would be a bonus. Ideal skills for this project: - Experienced in logo design, especially for sports or urban-themed groups - Proficient in using color theory effectively - Ability to innovate and create unique, memorable designs - Excellent at incorporating client's vision/feedback into the final product We will be looking for a few logo options to choose from, so creativity and variety in your submissions would be great...

I am looking for a specialized Brazilian freelancer who can create a persuasive media pitch presentation for me. The main goal of my presentation is to persuade viewers to invest or support an idea. Therefore, I am imagining a presentation with: - Graphs and tables to simplify complex data - Photographic images to create a strong impression - Diagrams to illustrate processes or strategies - General Slide Design Key information that needs to be included to support the pitch are market research findings and a diagrammatic strategy visually expressing plans and goals. Ideal freelancers should be proficient in graphic design and data representation, and understand the art of persuasion in presentations. Experience with investor presentations is a huge plus.

Recreate about 90 slides to a popular learning platform. Some images may need to be resized or replaced with stock images.

SEO from 17th May to 16th June

I have 20 pages that need some content generated from ChatGPT and entering on to the page. This includes a short bit of text (150 words) for the main content and YOAST meta descriptions. I'll provide full instructions and the correct prompts to use with ChatGPT. This is a super simple copy and paste job and should only take a couple minutes per page. Please be familiar with WordPress and ChatGPT so you can get this done quickly. Also you will need to update the DNS in your local hosts file to be able to access the site (I can show how) This is 1hrs work at most so please bid accordingly.