Write a query in sql to obtain the name of the physicians who are the head of each department. jobs

...need a Python program that can tap into Yahoo's fantasy football datasets using their API and extract various essential pieces of historical league-specific information. The main requirements of my project include: - Extracting information like player statistics, team standings, draft results, transactions (trades and adds/drops), weekly schedules (head-to-head matchups by week), weekly lineups, scoring settings, and league settings The Yahoo API Endpoints you'll need to use as inputs to derive the above data extracts for a particular league are: - the associated League ID (each league created by Yahoo is given it's own unique ID that a league member can provi...

hey there! I am working on a project with audio narration of the Bible stories that Jesus told (also called parables). The audio would be sent over and would be a straight reading of the text. Looking for someone to create a general vibe and color palette and have a lot of fun and bring their style into it and we could do potentially 10 of these stories together. They are around 30-45 seconds long each. Some stuff I have done with other animators is up at :)

Before you respond on Freelancer.com, please take a minute to read this document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 4-hour project to create a 30-second to 1-minute video (time can be slightly more or less, it is up to your judgment when making the video) The deadline is sacred, we cannot extend the 4 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - video ) --------...

...assistance to create engineered stamped plans for a residential home addition, specifically designed to add more living space. We would like a 2nd floor over the theater room that would attached to a 2nd car garage via breezeway with a finished 2nd story. - Existing Plans: My existing floor plans are only partial and might require some additional work to incorporate the new addition properly. We have a site plan and the proposed floor plan drawn to scale currently. - Construction Materials: The plan should be designed primarily using wood, ensuring structural integrity and compatibility with the existing building design. Also, advice on integrating utilities like HVAC, wate...

I'm running a Node.js website where the last user's data is mistakenly being displayed to the first user. This isn't the intended functionality, and I need an experienced developer to solve this issue promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in...

Please Sign Up or Login to see details.

...Overview: We are seeking an experienced Full-Stack Developer to spearhead the development and integration of key system components within our e-commerce platform. The successful candidate will lead initiatives to enhance user interactions by developing a WordPress plugin, building a robust .NET middleware API, and integrating advanced Azure-based messaging services. Additionally, the role involves creating an SDK to facilitate easy integration for third-party AI bot services. This position is crucial for ensuring that our platform not only meets current technological standards but also adapts to future advancements and user needs, enhancing both the scalability and functionality of our services. ...

I am seeking a professional photographer to capture high-quality images of a building located at 72-01 Queens Blvd. The objective is to obtain a comprehensive set of photographs that showcase the building’s exterior . ***long term potential project*** Location: Address: 72-01 Queens Blvd, Woodside, NY 11377, USA Photography Focus: Building exterior, architectural details. High-resolution digital images A minimum of 20-30 photos covering various angles and perspectives.. Deliverables: High-resolution images RAW formats. ( No edited needed just RAW formats ) HDR bracketing of each shot. Full rights for the use of images in marketing, web, and print materials. ...

Hi, I hope everybuddy is doing well. I am looking for someone capable of writing high-quality niche articles without plagiarism and without using AI for my blogs. The topics can vary, ranging from news to technology. The work needs to be done directly in WordPress, on the domain I provide. It is necessary to upload relevant images and make the logo to match the niche, and ensure that the website complies with all AdSense program policies. I am seeking someone who can assist me long-term in this project, which I am undertaking with several partners. I need qualified manpower. Thank you! Best Regards,

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

You must to be at least 16 years old and live in Latin America or Eastern Europe. ✻ NO EXPERIENCE REQUIRED ✻ You do not need any experience whatsoever, but you must be clever and eager to learn. No. I am *not* being charitable; rather, I am being practical. ✻ PAYING YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me....

Description: We are seeking a proficient product sourcing agent based in China who is adept at navigating and platforms. The objective of this project is to identify three verified suppliers for a specific product category and provide comprehensive details, including supplier contact information, lead time, and DDP (Delivery Duty Paid) pricing. Key Responsibilities: 1. Supplier Identification: Utilize and to search for reputable suppliers specializing in the specified product category. 2. Supplier Verification: Conduct thorough due diligence to verify the credibility and reliability of potential suppliers, ensuring they meet our standards for quality and reliability. 3. Supplier Contact I...

...translation project, converting a complex and unorthodox literary work from English to Portuguese. This narrative offers a deep and abstract exploration of life's decline, demanding a translation that captures its profound depth and nuanced Abstract Themes: Engage with a literary piece that pushes the boundaries of conventional storytelling, delving into the decline of life through an abstract and multifaceted lens. Your task is to translate this richly woven narrative from English to Portuguese, preserving its intricate details and underlying Translation Approach: Approach this translation with a sophisticated and nuanced mindset, ensuring the Portuguese version mirrors the o...

...Description:Embark on a challenging and intellectually stimulating translation project that involves converting a profound and unorthodox literary work from English to Portuguese. This narrative delves into the abstract and enigmatic themes surrounding the decline of life, requiring a translation that retains its complexity and Exploration and Translation: Immerse yourself in a literary work that defies conventional storytelling, exploring life's decline through a unique and abstract perspective. Your task is to translate this intricate narrative from English to Portuguese, preserving the essence and subtlety that define the original and Creative Approach: Adopt a nuanced and ...

Welcome to the "From The Inside Out Wellness Center" Logo Design Challenge! We are looking for a creative and original logo design that embodies the essence of our wellness center, focusing on energy-based work and spiritual practices. Our center offers a variety of services and activities aimed at promoting holistic well-being, personal growth, and spiritual development. The design should reflect our integrative heart-centered approach, helping individuals transcend to their higher selves and empower them on their journey towards optimal health, inner peace, and spiritual enlightenment. Design Guidelines: what we consider when we assign star ratings: 1. Name of the logo must be fo...

...be entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Causes for Caring << > Brand theme; love, caring, and charity with subtle connection to medical care > Brand Colors: We would like to see a variety of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Designs with contrasting elements which lead the eye toward the center of the icon ...

...conference, we need to create a set of graphics for PPC ads and social media. We currently use 2 styles of graphics in banners - one darker, where the background is always a photo with an overlay in ECD design, and the other lighter, rather infographic. For implementation, we would like to enter: - Brighter banner for PPC ads - Dark banner for PPC ads with Claim - Banner for promoting video recordings - Introducing the team - They moderate the event - Presentation of another E-shop Tour project - A PR article was published about the conference - Eventee application for networking - We are starting registrations - There will be practical workshops at the conference - C...

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Da...

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I need a word background editor for my CV and cover letter that's creative and understands a chef's profession. She/He must comply with this video tips: This tool must have: - Customizable templates for versatility. - The ability to alter font and color options. - Image insertion functionality to make visually engaging documents. The editor needs to work well with Microsoft Word and other word processing software. Ideally, it will offer designs specific to the culinary profession, creating a bold but professional impression of a head chef. Skills in graphic design and software development are preferred. Expertise or understanding of culinary aesthetics is a bo...

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should ha...

I need help organizing my nuisance case for summary judgement and maybe for trial on 9/16/24. I have a calendar of deadlines. I can supply drafts for motions and obtain affidavits. I am looking for support to make sure I comply with CA rules of procedure and filing with defense attorney and court .

I am seeking a talented graphic designer to create a modern and minimalist logo for my small company, The Royal Guardian. The logo must reflect the essence of my services - being professional and reliable. Key Requirements: - Design a modern and minimalist logo for The Royal Guardian - Convey professionalism and reliability in the design - Ensure the logo is unique and not reminiscent of any existing brands - Provide the logo in a high-resolution format for both digital and print use Ideal Skills and Experience: - Proven experience in designing modern and minimalist logos - A strong portfolio of previous work, particularly in branding and identity de...

...with persuasive sales skills and familiarity with the digital marketplace. Your mission, should you choose to accept it, will be to sell a wide variety of '.com' internet domain names - approximately 150 in total. Here's what you'll need to do: - Present domain names to potential buyers * Examples: , , - Be able to familiarize yourself with the full list of domain names when making sales. Key Notes: - This is a commission-based role, and I intend to reward successful sales generously. - No website design or layout is required as the sale is purely for the domain names. - There are no specific keywords or phrases related to the domain...

...need a Java or python3 programmer to create a sensor-data generator for the website www.voeazul.com.br. The objective is to send a POST request to the site with valid sensor-data in order to obtain a particular cookie (_abck) for data analysis purposes. The sensor data to be simulated includes mouse movements, keyboard interactions, and browser interactions. Key Requirements: - Create a sensor-data generator in Java or python3 - The generator should simulate mouse movements, keyboard interactions, and browser interactions - The sensor-data should be valid enough to trigger the generation of the _abck cookie upon sending a...

Develop a WeChat/Alipay app for a large-scale event in Hong Kong, you need to use it on WeChat/Alipay. It can be used by people in Hong Kong, Macau and China. The functions are mainly used to view event information, videos, reminder functions, mini games, contact customer service, and connect Department external website

...specifically interested in a 3D and animated style logo for this project. The logo will primarily be used on our website and Visiting Card and T-Shirt, so it should be versatile enough to look good in both digital and physical formats. You need to bring logo to life in 3D and in ANIMATION also....it should be moving. I have made a rough logo, please refer Attachment with this project, that's important INSTRUCTIONS-: I want this logo to be in Bluish and Orange colour theme Colour of "Resume" icon should remain the same. Icon should animate. Name should wave left to right ...or any other special effects also will do. Tagline to remain still Entire co...

Develop an WhatsApp bot to sell to our clients, based in IA chat and voice like Twillo, with Integration of the clients CRM/ERP's so that the bot can answer to the client with human language. with the Intranet. 2 When the CUSTOMER CALLS DETECT FROM AND Customer or not. 3 Hello Mr (name of the client) , how are you? 4. Hello, we have verified that you are not yet our Client 5 . What do you intend. 6. Speak to Our Commercial Department: Technical department Another subjects. After answering the questions, read our intranet If there is no response, I will pass it on to my colleague and pass it on to Human.

I will re-create the poster for him.

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these 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 t...

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

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...

...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&#...

More details: Is this project for business or personal use? For starting a new small business Which industry does your new enterprise fall into? Events / Wedding Florist What is the desired style for your business logo/branding? Elegant and classy but bright and whimsical at the same time? (Think Bridgerton and romantic English countryside) needs to have an impact though! Have attached a picture of my favourite dress and I love the colours! Do not have a colour scheme in mind but I have a love for English cottage gardens so something maybe along those lines. Would like a few to choose from! Have attached ideas for the logo (I’m definetly in my Bridgerton era) so maybe a sort...

More details: Is this project for business or personal use? For starting a new small business Which industry does your new enterprise fall into? Events / Wedding Florist What is the desired style for your business logo/branding? Elegant and classy but bright and whimsical at the same time? (Think Bridgerton and romantic English countryside) needs to have an impact though! Have attached a picture of my favourite dress and I love the colours! Do not have a colour scheme in mind but I have a love for English cottage gardens so something maybe along those lines. Would like a few to choose from! Have attached ideas for the logo (I’m definetly in my Bridgerton era) so maybe a sort...

I'm starting a new shop called "The Soft Touch", rooted in the Fabric and Textile industry. I need a creative freelancer with a knack for visually capturing business identities: - Develop a unique, eye-catching logo that reflects our name and fabric and textile focus. - Use the new logo to design an attractive business card. - Translate the aforementioned designs onto a display board to use at the shop display board. The perfect candidate will not only have a strong portfolio of previous graphic design work in these areas but also possess experience in fabric and textile design. A keen understanding of our industry will help pro...

...am seeking a proficient graphic designer to create a minimalistic agricultural logo. The design should embody simplicity, yet still have the ability to strongly represent my business. Key specifics: Our business name is Brown Agri Solutions, our slogan is Our solutions fix your problems. - My color palate choice would be a fusion of greens and browns. or Brown and light browns/gold. - The logo must incorporate a wheat symbol, an aspect quintessential to agriculture. extra points for encapsulating a spanner within the wheat head symbol - It's fundamental that the design is identifiable, easy to understand yet carries a level of sophistication. Ide...

...access to my property. Despite my previous attempts to address this issue with Cheshire West and Chester's planning department, they acknowledged the breach, but opted for nonintervention. I am seeking professional legal assistance from a freelancer with a strong background in property law and proven track record in handling similar cases. Key Responsibilities: - Understand the case circumstances - Develop and execute an effective legal strategy - Communicate with the neighbour and relevant authorities Ideal Qualification: - Law degree with specialisation in property law - Demonstrated experience in dispute resolution - Excellent interpersonal and negotiation skills Please note, I've ...

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

I'm in need of a talented label designer who can create a modern and minimalist wine label for my brand. "Clan McCauley Gin" Slogan: "Clan McCauley Gin: Crafted with heritage, enjoyed with friends." Logo: Design a logo that reflects the clan theme. You could incorporate imagery like a tartan pattern, a crest, or a stylized image of a family gathering. Bottle Design: Choose a bottle design that reflects the premium nature of the gin. A classic, heavy glass bottle with a simple label can be very effective. Bottle design for "The McCauley Cuvée" wine: Label Design: Since "Cuvée"...

I am seeking a full stack PHP developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience...

I need you to track a PNG file of a frog’s head that I provided. Please replace the main character’s head that is doing jump rope in the 26-second viral video with the frog’s head. Download:

We are seeking an experienced developer to convert the SPM12 GUI interface, currently built on the MATLAB compiler, into a Python application. The source code for SPM12 is available at SPM12 GitHub repository Objectives: • Translate the entire SPM12 codebase from MATLAB to Python while maintaining functionality. • Develop a Python-based GUI that replicates the current MATLAB interface. • Ensure the converted application integrates well with Python scientific computing stacks. Key Deliverables: • A fully functional Python version of SPM12. • Source code with comments and documentation. • A user guide for the Python-based GUI. Skills Required: &...

...seeking a creative individual who can craft a unique, brandable domain name for my web and software development company. The domain should be memorable, engaging, and reflective of the professional services I offer. Key Requirements: - The domain should reflect that I am a company focused on software and web development. - It should be suitable for targeting enterprise companies. - A catchy and engaging name is a plus. - Some keywords from my side like=> "Dev", "mind", "Pro", "Next" etc but I am open to your idea Ideal Freelancer: - Proven experience in domain name generation. - Creative and able to think outside the box. - ...

I have a scanned PDF document that needs some alterations. The primary tasks include changing the company name and updating contact information. Your expertise in both text editing and formatting is crucial for this project. Key Tasks: - Change company name: The new name should be seamlessly integrated into the document, replacing the existing one. - Update contact information: The current contact details in the document need to be replaced with the new information provided. Skills and Experience Required: - Proficiency in PDF editing: Experience with editing text in scanned PDFs is necessary, as the document is not in its original format. - Attention to...

...objective is to create short duration (5-10 minutes) documentary-style videos showcasing interesting video footage of your local models for our platform. We are hiring freelance video photographers like you, to shoot easy fashion style video shows with local female models you recruit for each project. You will be shooting projects where you are now located, with local women you invite to model for you, and we pay you from US$500 per shoot project, more once you become familiar with shooting for us. ModelsUpClose are video entertainment producers,  hiring video photographers from across the world in fashion style General Exhibition video shows since 1997.   It is essential we agree on your proposed...

Hello, I'm looking for someone who can assist me. The animation in the attached document shows boats within the iris of the eye. As I run a sports clinic, I would like to replace these boats with a sense of people winning, perhaps historical moments at championships that people recognize. The background is that I deal with both sports-specific injuries at my clinic and common ailments of regular individuals. The feeling to convey is that one can triumph over their troubles.

Do you have a deep understanding of Hyper converged infrastructure, cloud solutions, Virtualization and datacenter modernatizatio and a knack for translating complex technical concepts into clear, concise writing? We're seeking a skilled freelancer to create informative papers on various aspects mentioned below The ideal candidate will possess the following qualifications: In-depth knowledge of leading HCI solutions: VMware vSAN, NSX, HCX, Azure Stack HCI, etc. Solid grasp of HCI architecture: Distributed storage, software-defined networking, and resource management. Experience deploying, configuring, and managing HCI clusters: Proven track record of hands-on experience.
 Cloud Platforms : Proficency i...

...URGENT freelancer who can create a Thinkific course with a clean and minimalist design for my Head Spa business. The course should be geared towards working professionals and should incorporate video tutorials, written instructions, and interactive quizzes. |I also require my landing page on Thinkific to be worked on. It's half done but needs refining. You must be fast and efficient with examples of similar work you've competed. Please do not apply if you are juggling multiple projects. I need someone dedicated to getting this completed within a few days. The ideal candidate for this project should have: - Experience with Thinkific course creation - The ability to develop clear ...