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

...create exactly the same triangle graphic for a t-shirt print with different colors? I just need the triangle graphic here to put it on the t-shirt. The graphic is on the attachment. After the design, I need the data in vector format. The codes of the colors are: "Eden" = #0C414D (this is for the darkest triangles)(That is the most important color) "Gull Gray" = #9AB2B7 (this is for the second darkest triangles) "Geyser" = #C9D7DB (this is for the third darkest triangles) "Athens Gray +" = #DDE0E6 (this is for the fourth darkest triangles) "Athens Gray" = #EEEFF2 (this is for the fifth darkest tr...

PLEASE CHECK THE DESCRIPTION BEFORE SUBMITTING A BID Let's skip a boring description generated by AI. Actually, we are looking for a hero who helps us get all things about gambling in Spain, especially iGaming. We are not interested in bettings side of this market, only online casino games are in focus and all things around it, including main operators, target audience, regulative organisations, etc. Please don't use a complicated diagrams with numbers and dry copy paste, cause we have already done it on our side :) As result of this project we are waiting for simple and well structured document no matter pdf, page in Notion or Google docs. That will be a start...

I need to liquidate (sell) ) some the goods in Manila, need someone with experience in liquidation this information and quantity: The price we liquidate is given in column G, This is a very cheap price compared to the price I imported, and I guarantee it is the cheapest in the wholesale market Currently the goods are in my warehouse in Manila, please contact us for more detailed discussion

...for an experienced writer with a sound understanding of TikTok and marketing tactics to pen a comprehensive book. The book will serve as a guide for individuals aiming to utilize TikTok for their marketing endeavors. The ideal candidate will: - Have an in-depth knowledge of TikTok and its features. - Be familiar with the best practices for content creation on TikTok. - Understand effective TikTok advertising strategies. - Be proficient in interpreting and utilizing TikTok analytics and measurements for optimum results. - Produce an engaging and easy-to-follow guide suitable for a versatile audience from small business owners to social media influencers. No specific writing sampl...

I'm in need of a skilled Korean calligraphy artist (who is Korean itself and knows spoken Korean) to create custom name pieces for me in your unique style. Key Project Details: - I'm looking for someone experienced in Korean calligraphy to craft names in Korean in your own calligraphy style. The style can be Traditional calligraphy, Modern calligraphy, Brush lettering, or a fusion of your own. - The names can be either in Formal (Hanja), Semi-formal (Hangul), or Casual (Stylized Hangul). You are free to choose the style that you feel best suits the names. Application Requirements: - Please include examples of your past work specific...

I am looking for a good SEO to help me naturally reference my site and make it appear first in the Google, Bing, Ecosia, Yahoo and other search networks.

I am looking for a skilled developer or team to create a Python program designed for the efficient detection of surface defects on railway tracks. This tool is essential for ensuring the safety and operational efficiency of rail network covering high-speed and freight tracks. The program needs to be robust, capable of real-time defect detection and analysis, and capable of generating maintenance recommendations. Requirements: - Develop a Python program capable of converting video to images and image enhancement through filter and noise reduction. - It should capable of labeling of images and recognizing various surface defects including cracks, wear, corrosion, fractures, he...

As a fast-growing business, I urgently need a skilled Node.js developer to focus on backend development. The primary task is to integrate a payment gateway. We followed the instructions provided and implemented the following code using server-side Node.js. We utilized ngrok to enable HTTPS connections. We have successfully initiated a transaction using this code in the uploaded file. However, we encountered an issue retrieving the transaction, which should have been provided but is not available. We were advised to handle callbacks and decrypt the response, but we're facing difficulties in doing so. Handling callbacks and post-success payment URLs did not resolve ...

I am seeking expertise for my VLSI Magic project that requires: - High-complexity circuit design, calling for an in-depth understanding of intricate electronic circuit schematics. - Proficiency in logic synthesis, particularly in multi-level logic synthesis which is vital for my project. Part 1: Verify the design using a logic design tool. Part 2: Implement your design using Magic VLSI layout tool to generate your project layout Part 3: Test your design using irsim to simulate your project. Project submission should be two items: a- A report PDF file. (PDF) b- A compressed file containing all your codes, simulations, and results. (.zip, .rar)

We are looking for an experienced Django developer to implement an access control system in our existing web application. The access control system will allow the super admin to define access levels and assign them to team members. Each access level will determine which parts of the application a user can access. Key Features: Access Level Management: Implement functionality for the super admin to create, edit, and delete access levels. Each access level should have customizable permissions for different parts of the application. User Management: Allow the super admin to add, remove, and manage team members. When adding a team member, the super admin...

I need a proficient researcher and writer to handle a job of writing my PhD Confirmation of Enrolment document. The document has already been written but need to make it up to 6000 words or more. The field of study of my PhD is Translation. The research investigates the translation of specific transcriptions translated from Arabic into English and will be doing a parallel corpus study to do that. Key task: - Finish writing my PhD Enrollment Confirmation document while maintaining the academic integrity and tone of the document. - adjusting the title of thesis Ideal skills: - Experience in academic writing and research is highly preferre...

As the author of a children's book aimed at the 0-3 year age range, I'm seeking a talented illustrator, or someone with limited experience but a great talent match, to help me bring to life what's been in my head. Starting with around 21 pages but open to input and possibly less. Looking for engaging, warm basic black lines with fill in watercolors; light and airy, and cheerful. Key Requirements: * Playful watercolor artistry, kid-friendly style that appeals to the targeted 0-3 years old child. * Willingness to work with author to interpret what's in my head. Looking for someone to help bring my book dream to life. * Prof...

Please Sign Up or Login to see details.

I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawle...

I'm looking to hire an architect who can help me obtain a permit for building a sunroom from a kit. Here are some key points: - **Location:** The sunroom will be installed on a wooden deck that is attached to my house. It's essential that the blueprint includes the proper connection details to the existing structure. - **Size:** The sunroom is relatively small, around 112 sq ft (8' x 14'). It's important to design a space that is both cozy and functional, suitable for relaxation and leisure. - **Skills and Experience:** I need someone with experience in creating similar blueprints and obtaining permits for home additions. An architect...

I'm in need of an expert who can perform photo extraction from a PDF file. The key requirements for this task are as follows: - The extracted photos need to be saved as a single PDF document. I don't require individual image files. - The resolution quality of the extracted photos must be high - 300 DPI or more. Please ensure this whilst extracting as it's essential for the final output. - The photos extracted should ideally follow a random naming convention. The order doesn't necessarily need to adhere to the page number or alphabetical rule. The ideal freelancer for this task would have experience in handling image data e...

I need a professional with experience in Odoo to implement accounting reports in Odoo saas~16.3+e (Enterprise Edition). The reports should be exportable as XLSX or CSV files. Required Reports: 1- Account Payables Display tabs for each supplier. Information on invoices issued, quantity, and payment dates. 2-Inventory Summary Display existing inventory as of a specific date. Price and cost information. 3-Sales Tax Display total sales within a specified time period. Consider both taxed and untaxed sales. Additional Features: *Ability to specify dates for the report results. Example: For the "Inventory Summary FEB 2024" report, be able to search for results for January or other previous month...

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate sh...

...seeking corporate identity and branding services that reflect both the information technology (IT) and defense industry consulting sectors. Like Adidas, which uses multiple active logos, we desire separate and iconic logo designs for each sector. Desired Designs: Logo Designs: Minimalist, iconic logos that represent each department. For example, for the defense industry, a minimalist logo design featuring a Trojan horse head with armor details. Both logos should resemble each other by about 90%. Business Card Designs: Professional business cards for both sectors, incorporating company information and the logo designs. Social Media Graphics: Suitable profile and cover images for Facebook, Instagram, Twitter, Reddit...

I am searching for an experienced app developer who excels in designing and implementing Android-based applications. The main functionality required for this task is the creation of a comprehensive employee database system. Key Functionalities: • Instant tracking of employees' online and offline status • Storing and displaying contact details of each employee • Categorizing employees based on their department The developer should have a strong understanding of database structuring and management for Android systems and a proven track record of delivering similar projects. Familiarity with real-time data sync and user-friendly UI design are also desirable.

...Welcome! We are excited to present to you an exciting development project for an innovative and cutting-edge dating platform. Our mission is to revolutionize the online dating experience using artificial intelligence to create meaningful and authentic connections. **Project Objective:** Our goal is to develop a dating platform similar to , where users can interact with AI-generated profiles and engage in compelling and empathetic conversations. The platform must be able to charge users for private content and promote genuine emotional connections through interaction with AI. **Key Features:** 1. **AI-Generated Profiles:** We will use advanced AI generation algorithms to create profiles of...

...experienced React Native developer who can develop a functional driver app for both iOS and Android platforms. I already have UI screens, however, are open to guidelines and suggestions. The Primary function of the app would be easing the driving processes. Here's what I'm aiming for: - Operational across both: iOS and Android platforms - Integration with GPS tracking for precise navigation - Real-time notification capability - Streamlined payment processing The ideal developer for this project should have: - Proven experience in React Native Development - Proficiency in working with both iOS and Android platforms - Excellent understanding of GPS integration and real-time notifications - Ab...

I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete this task.

I am in need of a comprehensive contact list of various officers from the land department in Rawalpindi. The specific roles we are focusing on but not limited to, are: - Land Registry Officer - Land Acquisition Officer - Land Surveyor Even though the purpose of this list was not specified, it would be best if the freelancer background lies in research, networking, marketing or promotions as these are the probable intended uses. To complete this project successfully, freelancers should demonstrate: - Strong research skills - Knowledge of land department operations in Rawalpindi - Attention to detail Please, include examples of ...

...currently has a significant limitation: it only supports the store's primary currency, which in this case is the Polish Zloty (PLN). As I sell throughout the European Union, it is essential to add support for the Euro (EUR). At present, there is a problem with how prices are displayed in the abandoned cart emails. Since 1 Euro is approximately equal to 4 Polish Zloty, when a customer who shops in Euros abandons their cart, the reminder email incorrectly displays the prices in PLN but with a Euro symbol next to them. This causes confusion because the prices appear four times higher than they should be, which can be misleading and off-put...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would ...

I am in need of an expert in Google and Meta PPC campaign management and optimization, as well as tracking conversions, so Analytics, Google Tag Manager, and Meta's CAPI installation and management are a must. The clients we have running Google and Meta PPC campaigns are primarily in restaurants, e-commerce (billiards), and local mattress stores. It is not mandatory that you have experience in these industries, but it's a huge plus. I am not looking for someone who knows how to navigate Meta and Google Ads, create and run campaigns, etc. Anyone can do those things. We have seen many people look like they know what they're doing, but have had no ability to provide results. We are...

I am seeking support from a highly experienced cybersecurity(CIA) freelancer to assist in my research paper. Key objectives are: Optimal candidates should possess: - Strong writing and editing skills - A knack for structuring information effectively - The ability to create engaging and clear content however, no Chatgpt , no google Bard/Gemini, or any other AI tool. Cybersecurity CIA Analysis (2019-Present) Need in-depth analysis of CIA triad in recent research? 5 IEEE papers (2019-present) Comparative table with key insights ⚡ Fast, expert research & delivery Order now & unlock cybersecurity knowledge! Tags: cybersecurity, research, CIA, IEEE, analysis, comparison - Identifying potential vulnerabilities...

PLEASE CHECK THE DESCRIPTION BEFORE SUBMITTING A BID Let's skip a boring description generated by AI. Actually, we are looking for a hero who helps us get all things about gambling in Spain, especially iGaming. We are not interested in bettings side of this market, only online casino games are in focus and all things around it, including main operators, target audience, regulative organisations, etc. Please don't use a complicated diagrams with numbers and dry copy paste, cause we have already done it on our side :) As result of this project we are waiting for simple and well structured document no matter pdf, page in Notion or Google docs. That will be a start...

Need a freelancer to answer phone calls. After each phone call, the freelancer will fill out a 5-minute survey (it will be provided upfront). One phone call's average duration is from 3 up to 5 minutes. The goal is phone call evaluation. The price we will pay per phone call is $8, and you will usually receive one call per day. Condition: Freelancers need to speak the US English language very well. As part of the application process, we invite you to record 30 seconds of your voice speaking English. This is an opportunity for you to showcase your fluency and competence in the language. We are looking for long-term cooperation. Payments will be ...

Implement the given algorithm in javascript and HTML for visualization

Java developer who can work with flutter. As requirements are to integrate Java sdk in small flutter print app. We are integrating new android printer with Java SDK in flutter is fully working and printing already but we need to change the SDK as we are upgrading android printer. If you have experience of integrating java sdk into flutter app come forward.

write reflective report as a Risk manager for project management 1k-1.5k words in 24 hours Send me the details

I'm in need of an adept creative professional who can brainstorm a catchy, two-word name for a Management System Consulting company based in India. The name should reflect the concept of Consulting, Management Systems and embody a westernized tone. Specifics I require: - A trendy and easy-to-pronounce name - .com domain availability for the suggested name - A basic logo concept would be advantageous but not mandatory Successful bidders should have a background in creative writing, branding and possibly graphic design. Proficiency in understanding western and Indian business culture is a plus!

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize ...

My project necessitates a top-notch custom web-based ticketing system, prioritizing ticket submission, tracking, and superior user management. Key Features: - Ticket submission and tracking: The system should enable simple ticket submission and comprehensive tracking. Users should be able to monitor their tickets' progress with ease. Ticket Priorities: - The system must classify tickets with a three-tiered system: Critical, Major, and Minor. Each category should have its distinct features and priority level. User Roles: - The ticketing system should incorporate three crucial user roles: Admin, Agent, and User. - Admin: Full control over the entire system. - Agent: Responsible for handling and resolving tickets. ...

Simply recreate the given image with better quality and tweak it a bit so i can not get any copyright issues

Update a set of CAD drawing to reflect 'As Built' and additional pending changes. Stamp for submission to local building department in NYC. Includes floorplans, electrical and plumbing plans.

I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Pleas...

I, ("Person 1" in the explanation below), am in need of an attorney in Virginia, USA able to appear before a judge in Fairfax County, VA in person or by phone/video according to the rules of the VA court system. Does VA require you to be a member of the bar to appear before a judge? - Person 2 is resigning and Person 1 agrees, so it was not required that Person 1 filed in a VA court. - Person 2 is asking for back pay to which Person 1 agrees. - Person 1 tried to settle before filing. After filing, Person 1 is still trying to settle out of court. - Person 2 who is a VA lawyer, hired two more V...

The project encompasses the following requirements: 1. I don't need his life story. I don't need the case details. I need only the role of Radhabinod Pal in this case. 2. I would appreciate it if anyone could provide full judgment. Specifically his judgment. 3. Books and articles on this judgment written by Radhabinod Pal. 4. Textbooks, academic papers, and possibly multimedia resources on the role of Radhabinod Pal. I am seeking your assistance in curating a collection of specific references and books on Justice Radhabinod Pal (1886-1967), who served as the judge of the International Military Tribunal for the Far East (1946-1948). In deliberations with judges ...

Hi The Blend Nation, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

We are searching for a highly skilled and experienced developer to assist us in building robust API integrations using CloudQuery. Our project involves extracting and integrating data from various sources into our system for advanced data analysis and reporting. We're looking for a developer who can effectively use CloudQuery to build these integrations in a scalable and efficient manner. Key Responsibilities: Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team ...

I'm seeking an AI content writer for a significant article generation project. Key Project Details: - 700 articles required, each minimum of 1200 words - Budget fixed at 1000 rupees total. - Purpose of the articles is to provide useful information to readers Key Requirements: - Proficient in using AI tools for content generation - Ability to write engaging, informative content The project requirement is urgent, so I'm looking for someone who can commit to a quick turnaround while maintaining high quality content.

I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for ...

installation of theme and make the theme ready to be used

Looking for an experienced character animato...experienced character animator/ game programmer that has the skills to polish and finish an existing game coded in Unity. You must be very proficient in Unity game engine. Rigging and animation experience is a must. I need a rigging and animation expert as a matter of fact. We are working on a AAA on the rail game game in 1st person shooter style. I need someone who is good at taking existing assets and customizing them and making them better or using the existing animations very nicely. No rookies please. You will be asked to perform a test animation upon getting the full job, so if you are lying about expertise you...

I'm in urgent need of a diligent and experienced remote assistant who can help me streamline my daily tasks. Your main responsibilities will include data entry, email management, and calendar management. Key tasks include: - Conducting data entry: You'll be required to manage and organize data effectively. - Email management: Checking, sorting, and responding to my emails will be one of your daily tasks. - Calendar management: Organizing and scheduling appointments, meetings, and events will be part of your duty. As this is a daily role, you must be available and committed to this schedule. Moreover, I prefer email as the significant mode of communication. Prior experience in a si...

I have list of companies I am looking for a freelancer to provide me with the email address of people from that company, We are currently seeking contacts within the marketing and leadership domains for potential collaboration. Specifically, we are interested in the following job titles: Event Manager (including Event Director and Head of Events) Marketing Manager, Marketing Director, or Head of Marketing CEO or Founder, Co-Founder, Managing Director

Project Students are expected to design and build an interactive website based on the material learned in the class using content management systems such as Joomla. This project aims to allow students to use their innovativeness and creativity to build an e-business idea in small teams based on 2 students. Students can pick pure or partial e-business models that can have online transactions through a website. The project should contain all the components of a well-made website. It should include: • Web pages, videos, images, banners, menus • Forms • Server-side scripts • Database The following are some sample projects which you may work on one of them: ...